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

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 21 Apr 2005 19:53:15 +0200
Message-ID: <4267e859$0$32132$626a14ce@news.free.fr>

"Captain" <captain_2010_at_yahoo.com> a écrit dans le message de news:1114099738.761957.161370_at_o13g2000cwo.googlegroups.com...
| 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
|

Define "first"
Have a look at "group by": http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_103a.htm#2066420

Regards
Michel Cadot Received on Thu Apr 21 2005 - 12:53:15 CDT