Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 98D40475D91
	for <pgsql-sql@postgresql.org>; Sun,  8 Sep 2002 20:21:34 -0400 (EDT)
Received: from mail1.tpgi.com.au (mail.tpgi.com.au [203.12.160.57])
	by postgresql.org (Postfix) with ESMTP id A247C475B33
	for <pgsql-sql@postgresql.org>; Sun,  8 Sep 2002 20:21:31 -0400 (EDT)
Received: from jac (bri2-56k-217.tpgi.com.au [203.29.144.217])
	by mail1.tpgi.com.au (8.11.6/8.11.6) with SMTP id g890LXE02930
	for <pgsql-sql@postgresql.org>; Mon, 9 Sep 2002 10:21:33 +1000
Message-ID: <002201c25796$d923d3f0$1400a8c0@jac>
From: "jack" <datactrl@tpg.com.au>
To: <pgsql-sql@postgresql.org>
Subject: the best way to get the topest 3 record in every group
Date: Mon, 9 Sep 2002 10:21:30 +1000
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200209/33
X-Sequence-Number: 9310

Hi,
There is a table like :
<<
itemNo
supplier
purchaseDate
Price
Qty
<<
Please provide an idea if I want to get the latest 3 puchase records for
each item and supplier. Thank you in advance.

jack