Subject | RE: [firebird-support] FIRST SKIP syntax |
---|---|
Author | Louis Werth |
Post date | 2004-07-14T15:35:19Z |
Milan, thanks for your response!
Milan Babuskov Wrote :
And where would you like to have that total number of rows? As another
column which always has the same value?
Yes, as a new column. a Nice example would be:
Select first 10, TOTALROWCOUNT, field1, filed2
From myTable
Where field3 = 'ZZZ'
Where TOTALROWCOUNT would be the record count of the result set ignoring the
"FIRST" Statement.
I am trying to achieve the same as a Google web search. Display page 1 of
10. Where each page would have 10 records on it. (Speed and Less Network
Traffic)
Don't you think by implementing your suggestion would slow down the
preparing and executing of such a qry's.
Does anyone know if this functionality will be added in the future, or
correct me if I am asking for the unnecessary.
Regards
Louis Werth
Milan Babuskov Wrote :
And where would you like to have that total number of rows? As another
column which always has the same value?
Yes, as a new column. a Nice example would be:
Select first 10, TOTALROWCOUNT, field1, filed2
From myTable
Where field3 = 'ZZZ'
Where TOTALROWCOUNT would be the record count of the result set ignoring the
"FIRST" Statement.
I am trying to achieve the same as a Google web search. Display page 1 of
10. Where each page would have 10 records on it. (Speed and Less Network
Traffic)
Don't you think by implementing your suggestion would slow down the
preparing and executing of such a qry's.
Does anyone know if this functionality will be added in the future, or
correct me if I am asking for the unnecessary.
Regards
Louis Werth