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