统计每个用户的最新三笔订单记录

1. Mysql

2. SqlServer

查询语句：适用Mysql&SqlServer

SELECT  t2.user_id,
        t2.order_id,
        t2.create_date
FROM
(
	SELECT  user_id,
	        create_date,
	        ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY  create_date DESC) AS rn
	FROM tb_order
	GROUP BY  user_id,
	          create_date
) t1
JOIN tb_order t2
ON t1.user_id = t2.user_id AND t1.create_date = t2.create_date
WHERE t1.rn <= 3

查询结果