|Subject||Re: [firebird-support] How do I read a specific range of records from a table in the database|
> You are right, I am not sure how it was working but it should have been
> "SELECT COUNT(*) FROM SURFACE"
> SELECT FIRST n FROM only reads the first "n" records I want to read the
> "n" records to the end of the DB
> FYI, I am a newbie to SQL so I don't know the command syntax very well.
> I need is something like SELECT LAST n FROM but when I tried that I get an
> Is there something similar?
> SELECT FIRST N SKIP Y FROM MYTABLE ORDER BY ID DESCENDING
[Non-text portions of this message have been removed]