Count a Subquery with group clause

[Bin Gao]

Hello All,

How can I generate the following SQL statement using
OJB?

SELECT count(*) FROM (
    SELECT   lastname, age, city
    FROM     people
    GROUP BY lastname, age, city
);

Thanks for your help,

Bin

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]