Query to Generate serial number in sql

select ROW_NUMBER() over (order by columnname) as sno,columnname from tablename



Without Order by Particular column

 select ROW_NUMBER() over (order by (select 1)) as sno,City from tbl_City