子查询+连接查询+模糊查询

查询年龄比肖梅小的学生信息

SELECT borndate FROM student WHERE studentName=‘肖梅’;

子查询：在增删改查语句中嵌套使用另外一条select语句

外层sql：父查询 内层sql：子查询

嵌套：先子后父

SELECT * FROM student WHERE borndate>
(SELECT borndate FROM student WHERE studentName=‘肖梅’);

删除年龄比肖梅大的学生信息

DELETE * FROM student WHERE borndate<
(SELECT borndate FROM student WHERE studentName=‘肖梅’);

查询S1的学生信息

连接查询

SELECT * FROM student WHERE gradeId=(SELECT gradeId FROM grade WHERE gradeName=‘S1’);
SELECT * FROM student s INNER JOIN
grade g ON g.gradeId=s.gradeId
WHERE g.gradeName=‘S1’;

查询S1和S2的学生

SELECT * FROM student WHERE gradeId IN (SELECT gradeId FROM grade