MySQL query not working

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

i have just started learning php and mysql on my own after installig fedora 5 on my laptop just a week ago. i have creatd a table (winners) in mysql (from command line) and it has 2 columns. one is countryName and another is year. just like country and the year it won the football world cup. i want to make a query in terms of the names of the country/countries who have won the cup more than say 2 times. but i m struggling with it can any one help. the query i have created is

select countryName,count(*) as numberOfWins from winners where count(*)>2 group by country order by numberOfWins asc;

thanks.

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Perhaps not the most elegant method, and I'm away from my handy references, but try this:

Code:

select * from (select countryName, count(*) as numberOfWins from winners group by countryName) as a where numberOfWins >= 2;

Harry.

 

Cough - I forgot about 'having'.... Try this:

select countryName, count(*) as numberOfWins from winners group by countryName having count(*) > 2;



Harry.

 

thanks thanks a lot mate. it works