Home > mailing lists

Selecting top N percent of records. - Mailing list pgsql-general

From	Tim Uckun
Subject	Selecting top N percent of records.
Date	October 17, 2010 23:34:04
Msg-id	AANLkTimAcWFDvvzB2JLmFXTjM+_f1Kkj+7B1byxNxhzO@mail.gmail.com Whole thread Raw
Responses	Re: Selecting top N percent of records. (Darren Duncan <darren@darrenduncan.net>) Re: Selecting top N percent of records. (Peter Geoghegan <peter.geoghegan86@gmail.com>)
List	pgsql-general

Tree view

Is there a way to select the top 10% of the values from a column?

For example the top 10% best selling items where number of sales is a column.

Thanks.

pgsql-general by date:

From: "Turner, John J"
Date: 17 October 2010, 22:27:15
Subject: Re: installing from source in Windows

From: Darren Duncan
Date: 17 October 2010, 23:53:52
Subject: Re: Selecting top N percent of records.

Selecting top N percent of records. - Mailing list pgsql-general

Previous

Next