1、统计包含多少个不同的职业;
select count(distinct job) as n from yourtable2、统计每个职业包含多少人
select count(job) as n , job from yourtable group by job
select count(distinct job) as n from yourtable2、统计每个职业包含多少人
select count(job) as n , job from yourtable group by job
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货