>
>
> 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
> last
> "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.
> What
> I need is something like SELECT LAST n FROM but when I tried that I get an
> error.
>
> Is there something similar?
>
>
> SELECT FIRST N SKIP Y FROM MYTABLE ORDER BY ID DESCENDING

Alan


[Non-text portions of this message have been removed]