Re: Top ten?
From: I.Vinikovetsky <ilia_at_wescom.kharkov.ua>
Date: Fri, 23 Apr 1993 11:39:45 GMT
Message-ID: <1993Apr23.113945.18823_at_wescom.kharkov.ua>
Date: Fri, 23 Apr 1993 11:39:45 GMT
Message-ID: <1993Apr23.113945.18823_at_wescom.kharkov.ua>
Hi!
The decision proposed by Tom Donnell is not correct.
All where clauses act before group and order clauses, so your result in this
case (where rownum<11) will open to be random. You have to formulate where
clause on your "something" which will give you 10 top values BEFORE grouping
and ordering.
Cheers
Ilia Vinikovetsky, WESCOM Inc., Kharkov, Ukraine Received on Fri Apr 23 1993 - 13:39:45 CEST