17,086
社区成员
发帖
与我相关
我的任务
分享
select a.id,a.finalwrittenscore, (@JOB_ID := a.job_id) job_id
IF( @JOB_ID = a.job_id,@rank := @rank + 1,@rank :=1 ) AS rank
from t_exam a, t_job_information b, (select @rank :=0,@JOB_ID := NULL ) c
where t.paymentstatus = 1
and t.canclemark= 1
and t.job_id = j.id
order by a.job_id, a.finalwrittenscore desc