Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> How to get first record of each item only ?
hi,
>From below table want only the first value of each item id.
and how to get it, tried to use top n function in select statement
it takes only the first record.
itemid qty
1 10 1 5 1 15 2 20 2 15 4 10 4 5 4 2
Please help.
captain Received on Thu Apr 21 2005 - 11:08:58 CDT