简单的问题在线等
表名:table1
id a
1 aa-324-234
2 aa-324-2341
3 aa-324-23411
4 aa-324-234111
5 aa-324-23
6 b-34-234322
7 cxv-32423-1
8 xx-234-2344234234
9 sdfd-12321-111111111111111111
10 234-2342-123
我想得到table1里的a字段里的右边第3个“-”间隔数值最大的值
SELECT DISTINCT MAX(a) AS Expr1
FROM (SELECT DISTINCT
MAX(RIGHT(RIGHT(a, LEN(a) - CHARINDEX('-', a)), LEN(RIGHT(a, LEN(a)
- CHARINDEX('-', a))) - CHARINDEX('-', RIGHT(a, LEN(a) - CHARINDEX('-', a)))))
AS a
FROM TABLE1
GROUP BY a) DERIVEDTBL
GROUP BY a
这种方法为什么得不到呢?
最终的结果应该是111111111111111111。请高手求救 啊