need help on having clause

[Ram Korutla]

Hi

My objective is to identify records in a table where there is more than record with the same <col1,col2> combination.
Using the having clause, I can only check for one column right, how to get similar feature if I want to check on a combination
Please help

Thanks
Sridhar

[Hemavathy Ramamoorthy Gopal]

Hi Sridhar,

Please try out.

select * from table A where A.col1 = 'data' and A.col1=A.col2

or

select * from table A, table A1 where A.col1=A1.col2

Please reply with your feedback whether you meet your requirement or not.

[Christophe Verré]

Something like that ?

select * from t1 where col1,col2 in (select col1,col2 from t1 group by col1,col2 having count(*) > 1)

[Vinod Tiwari]

You should use self-join.