[prev in list] [next in list] [prev in thread] [next in thread] 

List:       turbine-torque-user
Subject:    subqueries in criteria
From:       "Neelima Yadla" <Neelima.Yadla () CBC-Companies ! com>
Date:       2007-07-27 14:31:43
Message-ID: DD010EBC85F76E40BCE279B40E0860C03F9E71 () CBCMAIL ! cbc ! local
[Download RAW message or body]


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

 

 



[prev in list] [next in list] [prev in thread] [next in thread]