DELETE FROM [dbo].[express_route]
WHERE [routeID] not in (
SELECT [routeID] FROM (
SELECT
MAX([routeID]) as [routeID],routeMailNo,routeOpCode
FROM
[express_route]
WHERE 1 = 1
GROUP BY routeMailNo,routeOpCode) A)
数据库删除重复多余的记录
最新推荐文章于 2023-12-28 10:30:28 发布