Re: [sqlite] counting distinctly

2004-09-16 Thread Darren Duncan
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

RE: [sqlite] counting distinctly

2004-09-16 Thread Downey, Shawn
] 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

RE: [sqlite] counting distinctly

2004-09-16 Thread Downey, Shawn
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

Re: [sqlite] counting distinctly

2004-09-16 Thread D. Richard Hipp
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

Re: [sqlite] counting distinctly

2004-09-16 Thread Brass Tilde
> 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;

[sqlite] counting distinctly

2004-09-16 Thread Downey, Shawn
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