select id,count(distinct track) from tracks group by id having count(distinct track)>=10;
Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate ________________________________ From: [email protected] [[email protected]] on behalf of chiefmccrossan [[email protected]] Sent: Thursday, July 21, 2011 2:15 PM To: [email protected] Subject: EXT :Re: [sqlite] Select names where occurences are greater than 10 Perfect! Thanks a million! =) Just wondering, is there anyway to select only unique results in what is returned and no duplicates? For example, Elvis Presley has a track called Teddy Bear in my table 6 times but I only want to include it once? luuk34 wrote: > > On 21-07-2011 18:59, chiefmccrossan wrote: >> >> I have a Tracks table containing columns for artistname and trackname. I >> want >> to be able to select all artist names that have more than ten tracks. For > > SELECT artisname, count(tracks) > FROM Tracks > GROUP BY artistname > HAVING count(tracks)>10 > > > >> example Elvis Presley has more than 20 tracks in the Tracks table but >> Johnny >> Cash has only 5 tracks. I need to be able to count Elvis and discount >> Johnny >> cash? >> >> Any idea how i can do this? >> >> Thanks >> Adam > > > -- > Luuk > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/Select-names-where-occurences-are-greater-than-10-tp32109108p32110258.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
