SQL语句逻辑执行顺序
select
(4
from (1
tb_name
where (2
group by (3
having (5
order by (6
limit (7
关联查询
join
inner join
left join
right join
full join
union
union all
left semi join
数据1:
1,a
2,b
3,c
建表
create table tb_a(
id int ,
name string
)
row format delimited fields terminated by ‘,’ ;
load data local inpath ‘/data/a/’ into table tb_a ;
数据2:
1,zss
2,lss
3,www
1,xxx
2,yyy
4,zzz
建表
create table tb_b(
id int ,
name string
)
row format delimited fields terminated by ‘,’ ;
load data local inpath ‘/data/b/’ into table tb_b ;
建好的两张表:
±---------±-----------+