27,579
社区成员
发帖
与我相关
我的任务
分享
取后三码最大值来判断,写法:
SELECT moduleCode, moduleName
FROM tb AS t
WHERE (NOT EXISTS
(SELECT 1 AS Expr1
FROM (SELECT moduleName, MAX(RIGHT(moduleCode, 3)) AS res
FROM tb
WHERE (t.moduleName = moduleName)
GROUP BY moduleName) AS m
WHERE (RIGHT(moduleCode, 3) < res) AND (moduleName = t.moduleName)))
SELECT moduleCode, moduleName
FROM tb AS t
WHERE (NOT EXISTS
(SELECT 1 AS Expr1
FROM (SELECT moduleName, MAX(RIGHT(moduleCode, 3)) AS res
FROM tb
WHERE (t.moduleName = moduleName)
GROUP BY moduleName) AS m
WHERE (RIGHT(moduleCode, 3) < res) AND (moduleName = t.moduleName)))