22,207
社区成员
发帖
与我相关
我的任务
分享
select 名,count(名) as Sum from (
select 名1 as 名 from tablename
union all
select 名2 as 名 from tablename
) as a
group by 名
select 名,count(名) from (
select 名1 as 名 from tablename
union all
select 名2 as 名 from tablename
) as a
group by 名