Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    5

    Question Unanswered: ROWNUM in sybase??

    Hi All,

    Can anyone tell me equivalent for ROWNUM(oracle) in sybase????
    I have to select only first record form resultet.
    I am new to sybase , any help will be appreciated..

    Thanks in advance

  2. #2
    Join Date
    Feb 2003
    Location
    Brisbane, Australia
    Posts
    110
    Try this:

    set rowcount 1
    go

    and if you want all results

    set rowcount 0
    go

    Cheers

Posting Permissions

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