#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Portugal
    Posts
    106
    Rep Power
    12

    Question How to use first(n) and skip(n)?


    when I run this query:
    select first(10) id from table1 it runs ok but if I run this one:

    select first(10) skip(5) id from table1 I get an error saying the connection was lost.

    Anyone knows how to use first(n) and skip(n)?

    I'm using Firebird 1.5 rc3
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Posts
    62
    Rep Power
    13
    select first 10 skip 5 id from table
    should work

IMN logo majestic logo threadwatch logo seochat tools logo