Count a Subquery with group clause

Bin Gao <[email protected]>
Newsgroups gmane.comp.jakarta.ojb.user
Message-ID <[email protected]> 
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.