SELECT cpr.Id, cpr.CreateTime, cpr.Number FROM CarParkingRegistration cpr
SELECT CONCAT(FORMAT(cpr.CreateTime, ‘yyyyMMdd‘), FORMAT(ROW_NUMBER() OVER (PARTITION BY CAST(cpr.CreateTime AS DATE) ORDER BY CAST(cpr.CreateTime AS DATE)), ‘000‘)) FROM CarParkingRegistration AS cpr WHERE cpr.StartDate IS NOT NULL
重点在于 PARTITION BY 按照时间分组。再定义出ROW_NUMBER。就是我们想要的。
原文：https://www.cnblogs.com/herenwei-wayne/p/11502298.html