现有学生表,包含学校名称,班级,学生姓名等列。需要查询某个学校学生姓名相同的学生的列表。
SELECT * FROM `studentInformation` WHERE studentname IN (SELECT studentname
FROM `studentInformation` WHERE school = '西安小学'
GROUP BY studentname
HAVING COUNT(studentname) > 1 AND school = '西安小学')
GROUP BY 分组,
HAVING 条件筛选,
IN 查询括号范围内的数据。