Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: rownum equivalent ?

    Hi,

    Rownum returns the serial number for the records in Oracle.
    Id there an equivalent for the same in SQL Server ?

    select rownum from test_table;

    Please advise,

    Thanks
    Sam

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    sqlserver has none, the clostest match is to add an identifier-column.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •