IMHO, if there is no need in solving the task with a
single query and one can use PL/SQL, cursor is a best way.
If no, the quickest and dirtiest is
select bill_seq_no, count(mobile_num)
from invoice
group by bill_seq_no
having count(*)=(select max(count(*)) from invoice
group by bill_seq_no)
;
--
Alexander I.Doroshko, aid_at_grant.kharkov.ua
- Bank "Grant", Kharkov, Ukraine
Richard Armstrong <StateOArt_at_worldnet.att.net> wrote in article
<7j46vg$77a$1_at_bgtnsc03.worldnet.att.net>...
: One way: (since you might want top counts that are equal)
:
: create table temp001 as
: select bill_seq_no, count(mobile_num) howmany
: from invoice
: group by bill_seq_no;
:
: select bill_seq_no, howmany
: from temp001
: where howmany =
: (select max(howmany)
: from temp001);
Received on Thu Jun 03 1999 - 03:50:50 CDT
