db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Dudziak <tom...@gmail.com>
Subject Re: How to COUNT DISTINCT over multiple columns ?
Date Sun, 18 Dec 2005 16:09:35 GMT
On 12/18/05, Bernt M. Johnsen <Bernt.Johnsen@sun.com> wrote:

> You're just missing a small detail:
>
> select count(*) from (select distinct person_id, project_id from person_project) as t(a,b);

Yup, thanks, that works!
But is there any chance for support for

  SELECT COUNT(DISTINCT person_id, project_id) FROM person_project ?

would make things a lot easier for us :-)
regards,
Tom

Mime
View raw message