Re: SELECT TOP XXX

Hi, all!

Dear Rolf, that won't work b'cos ordering works after selecting....

Use the following

1. select -column1 column2 from (select distinct -table.column column1 from table) where rownum<=XXX / /* You will get top XXX distinct values */

to get records, holding top XXX values, use

2) select column from table
  where column>=(select column2 from (select distinct -column1 column2 from

     (select distinct -column column1 from table) where rownum<=XXX) where rownum=1)
/

>Rolf Hauck writes in <367A0092.68AD338_at_datenrevision.de> ...
>select bla from table where rownum <= XXX order by blabla
>
>boonsong schrieb:
>>
>> I just try to find a select statement to get Top XXX Rows, anybody have
>> ideal

Best regards, Elias. Received on Fri Dec 18 1998 - 03:23:59 CST