DDL语句
# 查询出所有比赵六入学晚的学生信息
# 子查询
SELECT createDate from student where userName = '赵六';
# 父查询
select
*
from student
where
createDate>(
SELECT
createDate
from student
where
userName='赵六'#子查询
);
DDL语句
# 查询出所有比赵六入学晚的学生信息
# 子查询
SELECT createDate from student where userName = '赵六';
# 父查询
select
*
from student
where
createDate>(
SELECT
createDate
from student
where
userName='赵六'#子查询
);