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
在数据库处理数据