去除重复数据 ROW_NUMBER() OVER ( PARTITION BY os.OrderID ORDER BY os.ID DESC ) AS num 转载于:https://www.cnblogs.com/Harvard-L/p/7054572.html