Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2005
    Posts
    1

    Unanswered: selecting 7 out of 1000 rows

    Hi all,

    Please who knows how i can select the first 7 out of 1000 rows of a table.

    I've tried 'select top 7 ' ; but i get an error on a sybase engine.

    Does anyone know the command that runs on a sybase engine?

    thanks,

    olanreol@mtnnigeria.net

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    set rowcount 7
    select ...
    set rowcount 0
    Thanks,

    Matt

  3. #3
    Join Date
    Dec 2003
    Location
    FRANCE (Paris)
    Posts
    23
    Only ASE version 12.5.3 supports the TOP n clause

  4. #4
    Join Date
    Jan 2005
    Posts
    1

    Select TOP support in Sybase 12.5.3

    danmick,

    Could you please provide some more info / release information which states that SELECT TOP is supported in 12.5.3?

    I just need this to prove my customer

    Thanks,
    Abhijeet

  5. #5
    Join Date
    Dec 2003
    Location
    FRANCE (Paris)
    Posts
    23
    Ok,

    Go to this URL :

    http://www.sybase.com/products/infor...rverenterprise

    And download and read the document :

    "* Now Available - ASE 12.5.3 Interim Release with new functionality including Cross-Platform Dump and Load for simplified migration.
    Learn more from the ASE 12.5.3 New Feature's Guide "

    You'll find all informations about "TOP N" function available in ASE 12.5.3.

    Mickael

Posting Permissions

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