select a.A ,a.B,b.C from tmp1,
(select * from (
select b.*,row_number() over(partition by A order by rowid) as rk from tmp2 b)
where rk='1') b
where a.A=b.A
(select * from (
select b.*,row_number() over(partition by A order by rowid) as rk from tmp2 b)
where rk='1') b
where a.A=b.A
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货