某些属性相同的SQL选择组

我不知道你在期待什么,但去掉B&D

Select T.A,T.B,T.C from  Table T
INNER JOIN (
SELECT  B FROM Table
groUP by b
having count(B) > 1 )TT
ON T.B = TT.B

只需使用 exists :

select t.*
from t
where exists (select 1
              from t t2
              where t2.b = t.b and t2.a <> t.a
             );

t(b, a)