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 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 -- View this message in context: http://old.nabble.com/Select-names-where-occurences-are-greater-than-10-tp32109108p32109108.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