SQL面试题收录

1、用一条SQL语句 查询出每门课都大于80分的学生姓名

SELECT DISTINCT   NAME FROM  t_score_tab WHERE NAME NOT IN   (SELECT DISTINCT     NAME   FROM    t_score_tab   WHERE score <= 80)

2、查询两门或两门以上成绩都超过80分（含80）的学生姓名

SELECT   NAME FROM  t_score_tab WHERE score >= 80 GROUP BY NAME HAVING COUNT(1) >= 2