Re: Tricky SQL question

From: CT Canberra <ctcanb_at_dynamite.com.au>
Date: 6 Jan 1999 00:48:08 GMT
Message-ID: <01be390e$ca7ede30$35140c0a@eagle>

Thanks to Jurij Modic [jmodic_at_src.si] for the following solution. (Also thanks to everyone else who responded)

SELECT v1.data_type FROM
  (SELECT max(v2.keyword) data_type, v2.cnt FROM

     (SELECT keyword, -1*COUNT(*) cnt FROM keyword
      GROUP by keyword
     ) v2

   GROUP BY cnt
  ) v1
WHERE rownum <= 10;

Nice solution - fast too. :-)

-Richard B. Received on Tue Jan 05 1999 - 18:48:08 CST