Re: select rows matching a condition in each group

If you want to avoid using analytics, then a more performant version would be:

select *
from t
where
 (cb,cc) in (select cb, min(cc) from t group by cb)

... because it avoid the correlated subquery in your version.

Rgds.

VC Received on Fri Dec 26 2003 - 10:31:05 CST