Postgres Pro
Downloads
Home   >   mailing lists

Re: the best way to get the topest 3 record in every group - Mailing list pgsql-sql

From dima
Subject Re: the best way to get the topest 3 record in every group
Date
Msg-id 3D7C4108.70407@mail.ru
Whole thread Raw
In response to the best way to get the topest 3 record in every group  ("jack" <datactrl@tpg.com.au>)
List pgsql-sql
Tree view 
> 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
???

pgsql-sql by date:

Previous
From: "jack"
Date:
Subject: the best way to get the topest 3 record in every group
Next
From: "jack"
Date:
Subject: Re: the best way to get the topest 3 record in every group