34,838
社区成员




DECLARE @a TABLE(dm VARCHAR(20),mc VARCHAR(20),sl INT,dj FLOAT,zj FLOAT)
INSERT @a SELECT '001','aaaaa',3,10.00,30.00
UNION ALL SELECT '002','bbbbb',2,20.00,40.00
UNION ALL SELECT '003','ccccc',4,30.00,120.00
UNION ALL SELECT '001','aaaaa',2,10.00,20.00
UNION ALL SELECT '002','bbbbb',1,20.00,20.00
UNION ALL SELECT '003','ccccc',3,30.00,90.00
UNION ALL SELECT '001','aaaaa',2,15.00,30.00
UNION ALL SELECT '002','bbbbb',4,22.00,88.00
UNION ALL SELECT '003','ccccc',2,30.00,60.00
SELECT * FROM (SELECT DISTINCT dm,mc,dj FROM @a) a
WHERE (SELECT count(1) FROM (SELECT DISTINCT dm,mc,dj FROM @a) aa WHERE dm=a.dm AND mc=a.mc)>1
--result
/*dm mc dj
-------------------- -------------------- -----------
001 aaaaa 10.0
001 aaaaa 15.0
002 bbbbb 20.0
002 bbbbb 22.0
(所影响的行数为 4 行)
*/