On 9/22/2013 10:41 PM, Kristopher Roy wrote:
I have a table of songs, several have similar titles I can't find where to get started. I tried this but its not right. Select SongTitle, COUNT(SongTitle) AS LIKE_COUNT FROM Songs
What do you mean by "similar titles"? Show a representative sample of data in your table, and the result you would like to obtain from the query when run on that sample.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users