用户表:sys_user
姓名字段:real_name
示例:查询用户表中真实姓名相同的人的个数
SELECT real_name,count(real_name) AS countRealName FROM sys_user WHERE is_deleted=0 GROUP BY real_name HAVING countRealName > 1;
用户表:sys_user
姓名字段:real_name
示例:查询用户表中真实姓名相同的人的个数
SELECT real_name,count(real_name) AS countRealName FROM sys_user WHERE is_deleted=0 GROUP BY real_name HAVING countRealName > 1;