尝试：

Try:

SELECT ROW_NUMBER() OVER (ORDER BY Id) AS RowNum,* FROM myTable

SELECT ROW_NUMBER()  OVER (ORDER BY  ColumnName1) As SrNo, ColumnName1,  ColumnName2,ColumnName3 FROM  TableName