>>>>>>>>>>>> Thomas Dudziak wrote (2005-12-18 12:38:52): > SELECT COUNT(*) FROM (SELECT DISTINCT person_id, project_id FROM > person_project); > > doesn't work either, I get a > > ERROR 42X01: Syntax error: Encountered "<EOF>" at line 1, column 80. > > Is there a way to achieve this with Derby ?
You're just missing a small detail: select count(*) from (select distinct person_id, project_id from person_project) as t(a,b); -- Bernt Marius Johnsen, Database Technology Group, Sun Microsystems, Trondheim, Norway
pgpyTZwvHOREU.pgp
Description: PGP signature
