Home > mailing lists

Re: Select first ten of each category? - Mailing list pgsql-general

From	Yanni Chiu
Subject	Re: Select first ten of each category?
Date	April 13, 2006 02:09:10
Msg-id	e1kbrk$fdi$1@sea.gmane.org Whole thread Raw
In response to	Select first ten of each category? (Benjamin Smith <lists@benjamindsmith.com>)
Responses	Re: Select first ten of each category? (Michael Glaesemann <grzm@myrealbox.com>)
List	pgsql-general

Tree view

Benjamin Smith wrote:
> It has a LARGE number of entries. I'd like to grab the 10 most expensive items
> from each category in a single query. How can this be done?

Use a LIMIT on your SELECT. See:
http://www.postgresql.org/docs/8.1/static/queries-limit.html

pgsql-general by date:

From: Benjamin Smith
Date: 13 April 2006, 01:44:21
Subject: Select first ten of each category?

From: Michael Glaesemann
Date: 13 April 2006, 02:11:55
Subject: Re: Select first ten of each category?

Re: Select first ten of each category? - Mailing list pgsql-general

Previous

Next