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
Hemavathy Ramamoorthy Gopal
Joined: May 13, 2008
Please try out.
select * from table A where A.col1 = 'data' and A.col1=A.col2
select * from table A, table A1 where A.col1=A1.col2
Please reply with your feedback whether you meet your requirement or not.