让多个人参加考试多次为每个人保留最好成绩记录表生成排名表允许并列

     <select id="queryPageKsKshGood" parameterType="java.util.Map" resultMap="kskshPage">

    
     SELECT m.*
    
     FROM (SELECT ks.url,dense_rank() over (order by ks_ksh.fs desc) ranks,ks_ksh.id,ksh.`name`,ks_ksh.kscs,ks.jgfs,ks_ksh.fs,ks_ksh.sfjg,ks_ksh.delete_flag,
    
           ks_ksh.zql,ks_ksh.dfl,ks_ksh.ksys,ksh.sjh,dept.`name` deptName,k2.cjcs,ks_ksh.create_time
    
           FROM ks,ksh,ks_ksh,(select max(fs),ksh_id,ks_id,id,kscs,COUNT(1) cjcs
    
                               from (select * from ks_ksh where id having 1 order by fs desc) a