已知:一个技能表skill_table 一个岗位职责描述表v_data_clean, 需要求出技能的频率 SELECT skill ,count(*) as quantity FROM skill_table st inner join v_data_clean v on v.parse2_job_detail like concat('%',st.skill,'%') group by st.skill 结果