MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Select distinct order problems
Posted by: Ben Barnett
Date: April 09, 2005 10:01AM

Thanks for the post. I didn't realise that GROUP BY did a similar thing.

For the record, the query

SELECT COUNT(resource), resource FROM stats GROUP BY resource

lists each resource string and the number of times it occurs!

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Select distinct order problems
Ben Barnett
April 09, 2005 03:45AM
Re: Select distinct order problems
Claude Martin
April 09, 2005 04:59AM
Re: Select distinct order problems
Ben Barnett
April 09, 2005 10:01AM


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.