Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Top Value
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