select 字段1,字段2,字段3,字段4,count(*) from
(select 字段1,字段2,字段3,字段4 from 表1
Union all
select 字段1,字段2,字段3,字段4 from 表2) T
Group by 字段1,字段2,字段3,字段4
having count(*)>1
变态要求
MSSQL :
declare i int
Set i =
(Select count(*) from a group by 全部字段 having count(*) >1
-
Select count(*) from b group by 全部字段 having count(*) > 1)
Select top 2 * , count(*) from a group by 全部字段 having count(*) > 1
我都晕了,应该不行