If I want to select a certain set of rows
from my result set, which is the best possible
way to do it?
So far, I have been using rownum to "chop" my
select <column A, column b...> from <some table>
where <column A> in (
select <column a> from <some table>
where <condition> and
rownum <= 40) order by <column A> DESC)
and rownum <= 20
order by <column A> ASC
is there a cleaner way?
what's "row" and "rows" used for in Oracle?
i cannot seem to find examples for the usage...
Sent via Deja.com http://www.deja.com/
Before you buy.