34,575
社区成员
发帖
与我相关
我的任务
分享
select a.id ,count(a.id)
from a inner join b on a.id=b.id
group by a.id
select a.*,(select count(*) from b where b与a连接的条件) as 数量
from a
select
*
from
a
where
checksum(*) in(select checksum(*) from b)