select * from a inner join b on a.id<>b.id
select * from a where a.id in (select id from b)
select sum(a.amt) as total from a where a.total>20
select * from a inner join b on a.id=b.id
这道题你会答吗?花几分钟告诉大家答案吧!
扫描二维码,关注牛客网
下载牛客APP,随时随地刷题