Re: [Q] Daves's top 10 SQL question

here is a possible answer:
select <column>[,<column>]
from table[,table]
where rownum < 11
order by <order_columns>

so you see, oracle will retreive all the rows (order by does that) but you will get just the first ten.
note that you can still use group by etc.

how-ever, the real thing can be to define a cursor from that select and tehn fetching just the first 10 (in Pro*C it will be just one fetch, in Pl/Sql you'll have to work a bit harder)

good luck Received on Sun Mar 24 1996 - 00:00:00 CET