Say I have got table1 - col1,col2,col3. Table 2 is exactly same. How do I find out the values of col1 from table 1 which has got the same number of rows in both table1 and table2.I want to establish this in one single query.

An example will help explain your question better ...

Thanks

Sathyaram

Not sure if this is valid sytax with the "having" clause, but give it a try:

select a.col1, count(*) from table1 a
group by a.col1
having count(*) = (select count(*) from table2 b where b.col1 = a.col1)

That's a valid syntax ... Checked in V8.2

Cheers
Sathyaram