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
