例如查询t_teacher表中，手机号码重复的字段：
方法一：

SELECT phone, COUNT(*) 
FROM t_teacher 
GROUP BY phone  
HAVING COUNT(*) > 1;