>
> 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
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
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
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,
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
>
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
6 matches
Mail list logo