[sqlite] Select names where occurences are greater than 10

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

Re: [sqlite] Select names where occurences are greater than 10

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 >

Re: [sqlite] Select names where occurences are greater than 10

> > Advanced Analytics Directorate > > > > > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on > behalf of chiefmccrossan [adammccros...@gmail.com] > Sent: Thursday, July 21, 2011 2:15 PM > To: sqlite-users@sql

[sqlite] Update if exists or Insert if exists

Hi, I have a table called Test with one column called Name - CREATE TABLE "Test" ("Name" VARCHAR) I would like to insert a value into test if the name column is empty but if the column is not empty then I would like to update/overwrite the current value in the Name column. Can anyone please