MySQL父查询和子查询

# 查询出所有比赵六入学晚的学生信息
# 子查询
select createDate from student where userName='赵六';
# 父查询
select
*
from student # 写注释非常方便
where
createDate>(
		select
		createDate
		from student
		where
		userName='赵六' # 子查询
);