Re: Top Value

Thanks for your opinions,

The method Alexander gave worked ok. If the sze of the table gets very big in future, I may go for the cursor method.

Cheers

M

Mark Gumbs wrote in message <3755204d.0_at_145.227.194.253>...
>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 Thu Jun 03 1999 - 06:26:31 CDT