34,837
社区成员




SELECT *
FROM TABLE A
WHERE NOT EXISTS (SELECT 1 FROM TABLE WHERE YEAR(A.订单日期)=YEAR(订单日期) AND MONTH(A.订单日期)=MONTH(订单日期) AND DAY(订单日期)>DAY(A.订单日期))
--或者
SELECT *
FROM
(SELECT *,ROW_NUMBER() OVER (PARTITION BY YEAR(订单日期),MONTH(订单日期) ORDER BY DAY(订单日期) DESC) AS SEQ FROM TABLE) AS A
WHERE SEQ=1