the best way to get the topest 3 record in every group

From: "jack" <datactrl(at)tpg(dot)com(dot)au>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: the best way to get the topest 3 record in every group
Date: 2002-09-09 00:21:30
Message-ID: 002201c25796$d923d3f0$1400a8c0@jac
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message dima 2002-09-09 06:34:48 Re: the best way to get the topest 3 record in every group
Previous Message Colin Fox 2002-09-09 00:13:04 Efficiency Question