Gossamer Forum
Quote Reply
Help on COUNT DISTINCT
Hi, can someone point me the right sintax fo use in LinksSQL for the following?

select COUNT(DISTINCT LinkOwner) from Links

What I want is this:

User with listings:<%total_owners%>
using
Code:
sub {
my $total = $DB->table('Links')->count ( ['DISTINCT(LinkOwner)'] );
return $total;
}
but doesn't work...

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Blondies can have brains (sometimes...)

Last edited by:

SaraBem: Mar 6, 2007, 6:10 PM
Subject Author Views Date
Thread Help on COUNT DISTINCT SaraBem 2090 Mar 6, 2007, 5:38 PM
Thread Re: [SaraBem] Help on COUNT DISTINCT
Andy 2007 Mar 9, 2007, 12:42 AM
Post Re: [Andy] Help on COUNT DISTINCT
SaraBem 2000 Mar 12, 2007, 1:31 PM