View Single Post
  #9 (permalink)  
Old 07-16-2008, 06:43 PM
Dimitar
 
Posts: n/a
Default ANY answer. Re: Find duplicate entries in a table?

Quote:
Originally Posted by dandv View Post
That doesn't work in PostgreSQL:
ERROR: column "users.id" must appear in the GROUP BY clause or be used in an aggregate function
Yes, the statement is not valid according to SQL standards. It a documented behaviour of MySQL.
Reply With Quote