Subject | Retrieving First/Last record from a query. |
---|---|
Author | Bill Morrison |
Post date | 2001-10-29T22:40:21Z |
Afternoon Jason et al.
I have an interesting problem where I need to quickly retrieve the first and
last record of a queries result set (just doing select min(), max() from
blah isn't sufficient). Unfortunately, due to bandwidth constraints, reading
the entire table in isn't sufficient.
Is there a way through the existing IBO components to accomplish this, or is
my need best served with a sproc of some sort?
Thanks in advance,
Bill M
I have an interesting problem where I need to quickly retrieve the first and
last record of a queries result set (just doing select min(), max() from
blah isn't sufficient). Unfortunately, due to bandwidth constraints, reading
the entire table in isn't sufficient.
Is there a way through the existing IBO components to accomplish this, or is
my need best served with a sproc of some sort?
Thanks in advance,
Bill M