mysql分组后取最新的一条记录

1、mysql分组取每组前三条记录

#根据订单号（order_no）分组，每个订单取3个订单明细

ｓｅｌｅｃｔ *FROM ( ｓｅｌｅｃｔ *, ROW_NUMBER() OVER (PARTITION BY order_no ORDER BY create_time) AS row_num FROM order_goods_detail ) AS subqueryWHERE row_num