Monday, August 23, 2010

Auto Generated Serial Number in a SQL Query

select ROW_NUMBER() over (order by ID) as RowNumber from tableName

2 comments:

  1. Replies
    1. Hi Che Phyo Thet,
      i think you did not change query so please use it in this way
      select ROW_NUMBER() over (order by "YourTableColumnName") as RowNumber from "YourTable"

      Delete