如何用sql语句查询两个表中完全相同的两条记录答:如何用sql语句查询两个表中完全相同的两条记录 select f1,f2,...,fn from table group by f1,f2,...,fn having count(1)>1 查出存在相同的f1,f2,..,fn 想查找出记录则 select t1.* from table t1 join (select f1,f2,...,fn from table group by f1,f2,...,fn having count(1)...