asked
sql query to get the count from a column
I have a table with the following columns: SponsorID AccountID CountryID 123 456 236 123 789 236 123 654 40 123 897 236 123 978 40 123 564 40 ' ' ' ' ' ' ' ' ' I want to write a SQL query to find the sponsorIDs who have count of accounts having countryID = 40 more than 10 [ count(CountryID = 40) > 10 ]
You probably want something like... select sponsorid from yourtable where countryid =40 group by sponsorid having count(*) > 10
18 People are following this question.
