I have such problem:
need to get full record from a table that fits my conditions
SELECT * FROM groups WHERE grouptype=7 GROUP BY groupid HAVING
max(datecreate)>'2006-09-01'
Postgres tells i should group all fields but this fields have only same
groupid field value, and i need get full record. This must be a common
problem i think. How can i solve this?
