> 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
