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

Dima
My question is that I want to produce ALL the lastest 3 records for EACH
itemNo and supplier.

Jack
----- Original Message -----
From: "dima" <_pppp(at)mail(dot)ru>
To: "jack" <datactrl(at)tpg(dot)com(dot)au>
Cc: <pgsql-sql(at)postgresql(dot)org>
Sent: Monday, September 09, 2002 4:34 PM
Subject: Re: [SQL] the best way to get the topest 3 record in every group

> > 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.
> select * from table_name where supplier=value order by purchaseDate desc
> limit 3
> ???
>
>