sql语句使用记录_MySQL

查询存在重复的字段（mysql）

select nickname from user where school_id="swiftv" group by nickname having count(*)>1;