其他sql格式也在更新中,可直接查看俺的这个系列,要是没有你需要的格式,可在评论或私信我,俺现在一天一看
简单的子查询修改
oracle 原sql
select
(select b.name from B b where a.id= b.id) as name
from
A a
hive 改sql
select
b.name as name
from
A a
LEFT JOIN
B b
on a.id= b.id
nvl的子查询修改
nvl(E1, E2)的:如果E1为NULL,则返回E2,否则返回E1本身
oracle 原sql
select
(select b.name
from B b
where a.id= b.id)as name,
nvl((select c.code
from C c
where c.code= 'code'
and c.code= a.code),
a.code) as bankcode
from
A a
hive 改sql
select
b.name as name,
nvl(c.code,a.code) as bankcode
from
A a
LEFT JOIN
B b
on a.id= b.id
LEFT JOIN
C c
on c.code= 'code'
and c.code= a.code