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