On Apr 13, 2006, at 11:08 , Yanni Chiu wrote:
> 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
Without using UNION, (which would require writing a select statement
for each category), how would LIMIT allow him to do this for each
category in a single query?
Michael Glaesemann
grzm myrealbox com