[SQL] the best way to get the first record from each group

[q2005]

Hi,
Is there any better alternative to get the first record from each group?
"subno" is an integer, record with the smallest subno in each group is the
first record in the group.


select itemno, measureunit, extaxprice from itmt_purchase
   where subno in (select min(subno)as subno
   from itmt_purchase
   group by itemno   order by itemno)
   order by itemno, measureunit;



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 03/02/05


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])