On 7/21/2011 3:15 PM, chiefmccrossan wrote: > 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?
count(distinct track) -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
