Re: Newbie-Limiting rows returned in query

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

>careful with that one -- I don't understand the reference to hash-stuff.

i just saw that ora also supports hashed clusters etc. as hashfunctions almost never generate a meaningful order but allow you to group i wrote about that restriction

>It has
>always been true that group by does not have to sort (and in different character
>sets you can get truely strange results as group by does a binary sort when it
>does sort -- not a character set sort).

if i've got an index on the column of interest that should be used shouldn't it?

i understand the problems you state but if i don't have to deal with composites or these compisites are also pkeys in the desired sort order i should get what i expect. ..there are only two efficient ways of grouping: hashing or sorting..

does oracle 8 support a query like this (mysql-style)?

"select * from table limit firstrowofinterest,lastrowofinterest"

ciao, jan

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