由于我是虚拟数据。所以写得多一些，你直接引用表的话不会太长的（因为不知道你的mysql版本，如果是8以上的话，开窗函数更简单，一段就搞定了。如果是8以下没有开窗函数。所以相对要多写一段）

select t.company_name,t.jd_name,t.number_cot from(

select 'qqctn' as company_name,'一季度' as jd_name,75 as number_cot union all

select '山东公司' as company_name,'一季度' as jd_name,72 as number_cot union all

select '董家公司' as company_name,'三季度' as jd_name,68 as number_cot union all

select 'qqct' as company_name,'二季度' as jd_name,94 as number_cot union all

select '大山公司' as company_name,'四季度' as jd_name,54 as number_cot union all

select 'qqctn' as company_name,'二季度' as jd_name,53 as number_cot

)t join 

(select t2.company_name,max(t2.number_cot) as number_cot from (

select 'qqctn' as company_name,'一季度' as jd_name,75 as number_cot union all

select '山东公司' as company_name,'一季度' as jd_name,72 as number_cot union all

select '董家公司' as company_name,'三季度' as jd_name,68 as number_cot union all

select 'qqct' as company_name,'二季度' as jd_name,94 as number_cot union all

select '大山公司' as company_name,'四季度' as jd_name,54 as number_cot union all

select 'qqctn' as company_name,'二季度' as jd_name,53 as number_cot

) t2

group by t2.company_name) t3 on t.company_name=t3.company_name and t.number_cot=t3.number_cot

------------

select 

ORG_CNAME as company_name,

SLOT_TIME as jd_name ,

ACCESS_NUM as number_cot 

from tbiqd01 a 

join (select ORG_CNAME as company_name,max(ACCESS_NUM) as number_cot from tbiqd01 

  group by company_name) t3 on a.company_name=t3.company_name and a.ACCESS_NUM=t3.number_cot 

where a.SLOT_TIME_TYPE=1

SqlServer？oracle？mysql？