Subject Re: [firebird-support] FIRST SKIP syntax
Author Milan Babuskov
Louis Werth wrote:
> Is their any way to return the first 5 records in a dataset including a
> count of the total number of rows.

And where would you like to have that total number of rows? As another
column which always has the same value?

You can do it like this, but it's not efficient way of doing it:

select first 5 something, (select count(*) from table)
from table;

The best would be to issue two select statements.

Milan Babuskov