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 > sqlite-users@sqlite.org > 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
