Re: Newbie-Limiting rows returned in query

>select *
> from ( select * from T order by name )
> where rownum <= 10
>/

in oracle 7

select *
from ( select * from T group by name )
where rownum <= 10

does it if one doesnt use any hash-stuff.

ciao, jan

http://www.rsp.de - Software zur effizienten Erstellung und Verwaltung von Gutachten, Analysen, Pruefprotokollen etc. Received on Mon Dec 20 1999 - 04:27:12 CST