分组排序取每组前五 sql分组后取每组前10

sql数据库怎么实现分组并取每组的前1条语句？select * from ( select row_number() over(partition by ...