56,679
社区成员
发帖
与我相关
我的任务
分享
SELECT *,
IF(
(SELECT COUNT(*) FROM `tablename` tmp1 WHERE tmp1.score>95)<1,
IF(
(SELECT COUNT(*) FROM `tablename` tmp2 WHERE tmp2.score>tmp.score)<1
,'优秀'
,'称职'),
IF(score>95,'优秀',IF(score<80,'不称职','称职'))
) AS lev
FROM `tablename` tmp
ORDER BY score DESC