mysql，取舍某字段出现次数大于1的记录

mysql，选择某字段出现次数大于1的记录

table:

a b c d

1 a a a

1 a b c

1 b c d

选择b字段相同记录出现次数大于1的sql语句怎么写？

结果应为

a b c d

1 a a a

1 a b c

select a.* from a inner join

(select b from a group by b having count(*)>=2) b

on a.b=b.b