At 9:04 AM -0400 9/16/04, Downey, Shawn wrote:
Hello, I am new to sqlite and I wish to get the count of unique entries
in a particular field. The table is created as follows:
create table tablename
(
field_id char(10) not null ,
fieldname char(100)
);
create unique index findex on tabl
]
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
September 16, 2004 9:13 AM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] counting distinctly
> Hello, I am new to sqlite and I wish to get the count of unique
entries
> in a particular field. The table is created as follows:
> I get an error with the query:
> select (distinct fieldnam
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
> Hello, I am new to sqlite and I wish to get the count of unique entries
> in a particular field. The table is created as follows:
> I get an error with the query:
> select (distinct fieldname) from tablename;
> but this gives me the wrong answer:
> select distinct (fieldname) from tablename;
The version of sqlite I am using is 2.8.0
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: Downey, Shawn
Sent: Thursday, September 16, 2004 8:55 AM
To: [EMAIL PROTECTED]
Subject: RE: [sqli
6 matches
Mail list logo