Monday, August 23, 2010

Auto Generated Serial Number in a SQL Query 

select ROW_NUMBER() over (order by ID) as RowNumber from tableName
Posted by Ajay Rathore at 5:10 AM
Labels:

2 comments:

  1. MirrorNovember 15, 2012 at 8:46 PM

    It is not working in SQL

    ReplyDelete
    Replies
    1. Ajay RathoreNovember 15, 2012 at 9:09 PM

      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

Subscribe to: Post Comments (Atom)