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

Thread: About rownumber!

  1. #1
    Join Date
    Aug 2001
    Posts
    14
    Hi,
    In oracle there is Rownumber,but we can't find it in Ms-SQL,
    How can do it too in Ms-SQL?

    Regards,

  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Talking


    first, find an MS-sql bulletin board web site.

    We got Oracle gurus here. Unless there is some crazy ms-sqlWANNABE running around somewhere ...

    sorry that i do not know the answer.
    I assume you tried to select rownum.


  3. #3
    Join Date
    Jan 2001
    Posts
    318
    Use
    Select TOP 10 from....
    Sonali

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