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

2011-07-22 Thread chiefmccrossan
> > 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

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

2011-07-21 Thread Black, Michael (IS)
org] on behalf of chiefmccrossan [adammccros...@gmail.com] Sent: Thursday, July 21, 2011 2:15 PM To: sqlite-users@sqlite.org Subject: EXT :Re: [sqlite] Select names where occurences are greater than 10 Perfect! Thanks a million! =) Just wondering, is there anyway to select only unique results in w

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

2011-07-21 Thread Igor Tandetnik
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

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

2011-07-21 Thread chiefmccrossan
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? luuk34 wrote: > > On 21-07-2011 18:59,

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

2011-07-21 Thread Luuk
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 >