Subject Retrieving First/Last record from a query.
Author Bill Morrison
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