mysql如何查询各分组下top前五的数据

SELECT group_id, data
FROM (
  SELECT group_id, data,
         ROW_NUMBER() OVER (PARTITION BY group_id ORDER BY score DESC) AS row_num
  FROM your_table
) ranked
WHERE row_num <= 5;