Hi,
Is there any better alternative to get the first record from each group?
"subno" is an integer. The 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.6 - Release Date: 07/02/05
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
