Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [jai] SELECT DISTINCT

Quote Reply
Re: [jai] SELECT DISTINCT In reply to
I've come to the conclusion that the DISTINCT doesn't work with GT::SQL::Condition because it is not part of the WHERE clause. It needs to be used with the regular select clause as in -

my $sth = $table->select ('DISTINCT fieldname');

Is this correct??

Thanks

Simon.

To see DISTINCT incorporated with a seperate GT::SQL::Condition (WHERE clause) take a look at http://gossamer-threads.com/...orum.cgi?post=232703

Last edited by:

jai: Feb 14, 2003, 5:47 AM
Subject Author Views Date
Thread SELECT DISTINCT jai 4889 Feb 9, 2003, 8:58 PM
Thread Re: [jai] SELECT DISTINCT
jai 4788 Feb 11, 2003, 1:28 AM
Thread Re: [jai] SELECT DISTINCT
Paul 4809 Feb 11, 2003, 2:16 AM
Thread Re: [Paul] SELECT DISTINCT
jai 4742 Feb 11, 2003, 3:44 PM
Thread Re: [jai] SELECT DISTINCT
Paul 4747 Feb 11, 2003, 3:53 PM
Thread Re: [Paul] SELECT DISTINCT
jai 4763 Feb 11, 2003, 8:18 PM
Thread Re: [jai] SELECT DISTINCT
jai 4710 Feb 14, 2003, 5:41 AM
Post Re: [jai] SELECT DISTINCT
Paul 4755 Feb 14, 2003, 5:51 AM