sql如何使各个查询词，按一定条件降序取前十条

Question

如何使每个查询词，按score降序，各取前十条
select * from （'表'）
where key_word_1 in ('查询词1','查询词1')
order by score desc

Answer 1

select * from (
select *,row_number() over(partition by keyword order by score desc) rn
from （'表'）
where key_word_1 in ('查询词1','查询词1') ) tb
where rn <=10