Oracle 9i SQL 集锦

1.   select a,b,c ,count(*)   from tableName group by a,b,c having count(*)>1.
2.   select * from table1 a where (a.a1,a.a2,a.a3)in(select a1,a2,a3 from table2).