subqueries in criteria

[Neelima Yadla]

Hi,

 

How to write criteria for the following sql,

 

select count (*) from (select first, max (second), third

from testtable

group by first, third

 

Thanks,

Neelima