Top Value

Hi,

I have a statement

SQL> select bill_seq_no, count(mobile_num)   2 from invoice
  3 group by bill_seq_no;

BILL_SEQ_N COUNT(MOBILE_NUM)

---------- -----------------
MD0                       14
MD1                        5
MD2                        1

How can i rewrite the statement so it only returns the 1st line (MD0, 14)? Rownum won't help.

M Received on Wed Jun 02 1999 - 07:24:46 CDT