select * from o_user_answer as a
where score=(select max(b.score)
from o_user_answer as b
where a.user_id = b.user_id
) order By score desc,answer_time asc
;
修改过程:
1.建立一个视图max_click,存储的是每个类别最大的点击量
- create view max_click as select max(click_num) as click_num,kind
- from code
- group by kind;
2 .筛选,保证每个类别只有一条记录
- select *
- from (select id,kind,click_num
- from code
- where click_num = ( select b.click_num
- from max_click as b
- where code.kind = b.kind
- )
- ) as a
- group by kind;