COUNT(*) Question
mysql> SELECT Refer, COUNT(*) FROM tracker WHERE Refer NOT LIKE "http://%dlo.ne
t%" AND COUNT(*) GROUP BY Refer;
I have this query. How do I order by count and select only groups with a count(*) greater than 1?
------------------
[url=http://dlo.net[/url]
We know Have Game Reviews
Randall posted this at 00:28 — 18th May 2000.
They have: 141 posts
Joined: Aug 1999
I used a Temp table, is there an easier way though?
------------------
[url=http://dlo.net[/url]
We know Have Game Reviews
Ralph Slate posted this at 13:27 — 18th May 2000.
They have: 32 posts
Joined: Mar 2000
Select col1, count(*) as thecount
group by col1
having thecount > 1
order by thecount
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.