weixin_42142924的博客

原创 MYSQL 按名字分组查询最好成绩

员工可以多次答题，取最好成绩，按照答题分数，答题时长做排名。SELECT b.USERNAME,b.SCORE,b.ATIME,b.CORRECT,b.ERROR,u.NAME,t.TITLE FROM (SELECT a.USERNAME,a.SCORE,a.ATIME,a.CORRECT,a.ERROR,a.TESTPAPER_ID FROM EXAM_ACHIEVEMENT a WHERE TESTPAPER_ID='222' AND a.SCORE HAVING 1 ORDER BY a.SCO