select * from ky02 where aae043=201402 ----8条数据
A01 A02
----------
111 A
222 B
222 B
333 C
333 C
333 C
444 D
555 E
select * from ky02 where aae043=201402 ----3条数据
A01 A02
-----------
111 A
444 D
555 E
查询出两组数据相差的数据:----5条数据
A01 A02
--------------
222 B
222 B
333 C
333 C
333 C
并且按照条数来排序:
A01 A02 sum
--------------
333 C 3条
222 B 2条
.
.
.
------解决方案--------------------
仅参考
SELECT a01,a02, COUNT(1) SUM
FROM (select a.a01,a.a02 from ky02 a where a.aae043=201402
MINUS
select b.a01,b.a02 from ky02 b where b.aae043=201402)
GROUP BY a01, a02 ;