Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2008
    Posts
    1

    Unanswered: Sybase equivalent of MySQL limit

    Just looking for a way to limit the number of rows returned.

    In mySQL I would use:

    select * from myTable limit 10

    in Sybase I use:

    ???????????

  2. #2
    Join Date
    Mar 2007
    Posts
    72
    hi

    set rowcount 10
    select * from xxxx
    go

    to revert back to usual

    set rowcount 0
    go

    suda

  3. #3
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    select top 10 * from myTable

  4. #4
    Join Date
    Mar 2007
    Posts
    72
    top 10 only work in 15 not in 12.5.x

Posting Permissions

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