子层查询
SELECT createDate FROM `student` where userName='赵六';
效果图
父层查询
select * from student where createDate>
(SELECT createDate FROM `student` where userName='赵六');
SELECT createDate FROM `student` where userName='赵六';
select * from student where createDate>
(SELECT createDate FROM `student` where userName='赵六');