Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to get first record of each item only ?

Re: How to get first record of each item only ?

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 21 Apr 2005 23:38:02 -0700
Message-ID: <1114151882.497494.256400@g14g2000cwa.googlegroups.com>


select * from ( select * from THE_TABLE ORDER BY THE_ORDER_YOU_WANT) WHERE ROWNUM = 1; Cheers. Received on Fri Apr 22 2005 - 01:38:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US