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 Mon, 19 Dec 2005 13:24:49 GMT
> Don't think many databases has implemented COUNT(<row value expression>)
>
> although it has been in the SQL standard since '92.
>
> COUNT(DISTINCT col) works, though

May be, yes. Would be nice though if Derby supports more than one
column in the COUNT DISTINCT inner expression.
But the COUNT(*) on a sub select works nicely, so no real problem there.

regards,
Tom

Mime
View raw message