Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to get first record of each item only ?
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