Postgres Pro
Downloads
Home   >   mailing lists

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

From jack
Subject the best way to get the topest 3 record in every group
Date
Msg-id 002201c25796$d923d3f0$1400a8c0@jac
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Joe Conway
Date:
Subject: Re: Hardware performance for large updates
Next
From: dima
Date:
Subject: Re: the best way to get the topest 3 record in every group