The inline view is a luxury. Regards, Stephane Faroult On Tue, 20 Jul 2004 04:44 , Raj Jamadagni <rjamya@xxxxxxxxx> sent: anyone considered following ?? select a, least(cnt,100) from (select a,count(*) from my_table group by a) / Raj ===== Best Regards Raj --------------------------------------------------------- select mandatory_disclaimer from company_requirements; __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail[1] ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com[2] ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx[3] put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/[4] FAQ is at //www.freelists.org/help/fom-serve/cache/1.html[5] ----------------------------------------------------------------- --- Links --- 1 modules/refer.pl?redirect=http%3A%2F%2Fpromotions.yahoo.com%2Fnew_mail 2 modules/refer.pl?redirect=http%3A%2F%2Fwww.orafaq.com 3 javascript:parent.opencompose('oracle-l-request@xxxxxxxxxxxxx','','','') 4 modules/refer.pl?redirect=http%3A%2F%2Fwww.freelists.org%2Farchives%2Foracle-l%2F 5 modules/refer.pl?redirect=http%3A%2F%2Fwww.freelists.org%2Fhelp%2Ffom-serve%2Fcache%2F1.html ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------