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

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

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

row_number() over(partition by keyword order by score desc)<=10

不会的话，顶多再来一层子查询就行了呀 ,mysql就使用limit，oracle可以使用rownum

 
select * from （'表'）
where key_word_1 in ('查询词1','查询词1')
order by score desc   limit 10;