[SQL] - Adding Row/Serial Number to Any Database Query

[abu_arqam]

You can use :-

SELECT ROW_NUMBER() OVER (ORDER BY ColumnName1) As SrNo,ColumnName1,ColumnName2,ColumnName3 from Tablename

Thanks