Quick Links

Re: Select first ten of each category?

From:	Yanni Chiu <yanni(at)rogers(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Re: Select first ten of each category?
Date:	2006-04-13 02:08:49
Message-ID:	e1kbrk$fdi$1@sea.gmane.org
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

In response to

Select first ten of each category? at 2006-04-13 01:16:09 from Benjamin Smith

Responses

Re: Select first ten of each category? at 2006-04-13 02:16:59 from Michael Glaesemann

Browse pgsql-general by date

	From	Date	Subject
Next Message	Michael Glaesemann	2006-04-13 02:11:26	Re: Select first ten of each category?
Previous Message	Merlin Moncure	2006-04-13 01:18:05	Re: Leverage your PostgreSQL V8.1 skills to learn DB2