How can I associate the serial no in the result set (which is generated by select query) to display it as serial no.?

116.

select Col1,Col2, row_number() over(order by Col2) as [Serial No] from table

select Col1,Col2, rownumber() over(order by Col2) as [Serial No] from table

select Col1,Col2, Serial_ No from table

select Col1,Col2, row_number() as [Serial No] from table

None of these

No description found.