the best way to get the first record from each group - Mailing list pgsql-sql

From q2005
Subject the best way to get the first record from each group
Date
Msg-id 009401c50ac3$b841d5f0$1400a8c0@jac
Whole thread Raw
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Antony Paul
Date:
Subject: Can tsearch replace ilike queries ?
Next
From: "Levente Lajko"
Date:
Subject: Updating selected record