Thank you.  That did it.

Shawn M. Downey
MPR Associates
632 Plank Road, Suite 110
Clifton Park, NY 12065
518-371-3983 x3 (work)
860-508-5015 (cell)


-----Original Message-----
From: D. Richard Hipp [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 16, 2004 9:32 AM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] counting distinctly

Downey, Shawn wrote:
> 
> I wish to get the count of unique entries

SELECT count(*) FROM (SELECT DISTINCT column FROM table);
-- 
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565

Reply via email to