Sr No display in Query

SELECT rank () over (order by <Column1>) as Sr_No,
Column1
FROM <TableName>

Use XML Path In SQL Server

SELECT  SUBSTRING(( SELECT DISTINCT ( ',' + Email )
                    FROM    TableName
                  FOR
                    XML PATH('')
                  ), 3, 1000) AS EmailList