自关联查询的基本操作
- 准备工作:
- sql数据文件在下面连接自取
提取码为:n0ug
查询所有的省和自治区
select * from province where pid=0;
统计中国所有的省和自治区和直辖市:
查询广东省都有哪些城市(想象成两张表):
select p.name,s.name from province as p inner join province as s on s.pid=p.id where p.name = "广东省";
select * from province where pid=0;
select p.name,s.name from province as p inner join province as s on s.pid=p.id where p.name = "广东省";