Hello! I hope that someone here could help.
I'm using PostgreSQL7.1.3 I have 3 tables: entry, subcategory and category. The table "entry" has a foreign key "subcategoryid" with reference to the table "subcategory", and the "subcategory" table has a foreign key "categoryid" with reference to the table "category" I have the following SQL query : "SELECT * FROM entry where isapproved='y' AND subcategoryid IN (SELECT id FROM subcategory WHERE categoryid='"+catID+"') ORDER BY subcategoryid DESC"; For a given categoryid, this will return all entries in the "entry" table having a corresponding subcategoryid(s). But I want to return only a limited number of entries of each subcategory..... let's say that I want to return at most 5 entries of each subcategory type ( for instance if the inner subquery returns 3 results, thus I will be having in total at most 15 entries ).... How can this be achieved? I'm aware of postgreSQL "LIMIT" and "GROUP BY" clause..... but so far, I'm not able to put all this together... Thanks in advance. Arcadius. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
