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: [sqlite] I need a SQLite3 Wrapper for Java.
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)
