MySQl时间自定义排序
SELECT idcard,name,CreateTime,
ROW_NUMBER() OVER (PARTITION BY IDCard,DATENAME(yyyy,CreateTime) ORDER BY TID) AS OrderRank
FROM Gkv_test where
作者 jack1210
MySQl时间自定义排序
MySQl时间自定义排序
ROW_NUMBER() OVER (PARTITION BY IDCard,DATENAME(yyyy,CreateTime) ORDER BY TID) AS OrderRank
FROM Gkv_test where