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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
