group by having

2019-05-13 本文已影响0人 geeooooz

select * from xi a where (a.username) in (select username from xi group by username having count(*) > 1)