查询和“s001”号同学所学课程完全相同的其他同学的学…

 SELECT
	*
FROM
	test_student
WHERE
	sno IN (
		SELECT
			tsc.sno
		FROM
			(
				SELECT
					group_concat(cno ORDER BY cno ASC) AS strcno,
					sno
				FROM  
					test_sc
				GROUP BY
					sno
				
			) tsc
		WHERE
			tsc.strcno = (
				SELECT
					group_concat(cno ORDER BY cno ASC)
				FROM
					test_sc
				WHERE
					sno = '2'
				GROUP BY
					sno
			)
	) AND sno != '2'