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