DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: rownum in sql server

  1. #1
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi friends,
    Can any one let me know how to find rownum in sql server

    thanks in advance

    cheese
    anandkl
    anandkl

  2. #2
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295

    Lightbulb

    I think you will find that ROWNUM is a logical/derived field in Oracle not found in SQL Server.

    Are you looking for an Idenity field/Primary Key?
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

Posting Permissions

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


Click Here to Expand Forum to Full Width