> support for count(distinct) has been added in 3.2.6
> your version is certainly < 3.2.6 (sqlite -version)
Your are right. My version is 3.1.3
Thanks a lot for all your inputs folks :-)
--
Bharath
On 2/27/08 4:31 PM, "Cyril SCETBON" <[EMAIL PROTECTED]> wrote:
> support for count(distinct)
support for count(distinct) has been added in 3.2.6
your version is certainly < 3.2.6 (sqlite -version)
Bharath Booshan L wrote:
> -- Forwarded Message
> From: Bharath Booshan L <[EMAIL PROTECTED]>
> Date: Wed, 27 Feb 2008 14:32:14 +0530
> To: Eugene Wee <[EMAIL PROTECTED]>
> Conversation:
Hi Bharath,
Works for me in 3.4.2
SQLite version 3.4.2
Enter ".help" for instructions
sqlite> create table tst( nun integer, nm text );
sqlite> insert into tst values( 23, 'A' );
sqlite> insert into tst values( 23, 'b' );
sqlite> insert into tst values( 24, 'C' );
sqlite> insert into tst values(
-- Forwarded Message
From: Bharath Booshan L <[EMAIL PROTECTED]>
Date: Wed, 27 Feb 2008 14:32:14 +0530
To: Eugene Wee <[EMAIL PROTECTED]>
Conversation: [sqlite] Query to Find number of distinct records
Subject: Re: [sqlite] Query to Find number of distinct records
I was off for lunch
> The
4 matches
Mail list logo
