MySQL Forums
Forum List  »  InnoDB

Problems with COUNT (*) in a query
Posted by: Ricardo Alcaide
Date: March 14, 2005 05:41AM

I do not know how to retrieve from a table only values with more than one repetition.

This is the SELECT what I've thought it would be ok but it doesn't work

SELECT c.a, c.b., c.c, COUNT(*) AS d From c WHERE d>1 GROUP BY c.a

Any help will be wellcome

Options: ReplyQuote


Subject
Views
Written By
Posted
Problems with COUNT (*) in a query
2919
March 14, 2005 05:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.