Re: Top Value

From: Frans Hovenkamp <Dieze_at_popin.nl>
Date: Thu, 3 Jun 1999 08:13:17 +0200
Message-ID: <7j56cp$7dj$1@zonnetje.NL.net>

Mark Gumbs heeft geschreven in bericht <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
>

Read this page: http://www.arrowsent.com/oratip/ Select tip archive / SQL tips, tip #38
there' s a complete explanation of your problem

Frans Received on Thu Jun 03 1999 - 01:13:17 CDT