sql查询——子查询

时间:2022-11-20 22:32:51
1 -- 子查询
2       -- 一句查询语句内,再套一句查询语句 ,叫子查询
3       -- 查询班级类身高最高的人的名字
4       select name from students where high=(select max(high) from students);
5       select id as "序号", name as "姓名",high as "身高" from students where high=(select max(high) from students) order by id desc;
6       -- 查询省份下的所有区市,不知道省份的id
7       select name from china pid=(select id from china where name="四川省");