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 tablename
(field_id);
I get an error with the query:
select (distinct fieldname) from tablename;
but this gives me the wrong answer:
select distinct (fieldname) from tablename;
Sorry for such a novice question and thank you for any help.
Shawn M. Downey
MPR Associates
632 Plank Road, Suite 110
Clifton Park, NY 12065
518-371-3983 x3 (work)
860-508-5015 (cell)
