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