https://blog.csdn.net/gplihf/article/details/52678722
查到9比10大的写法:
SELECT MAX(ID) AS ID FROM DCP_ZB
正确的写法:
SELECT MAX(CAST(ID AS INT)) AS ID FROM DCP_ZB
原因:id是char 类型,需要把char 类型转为int 进行比较
https://blog.csdn.net/gplihf/article/details/52678722
查到9比10大的写法:
SELECT MAX(ID) AS ID FROM DCP_ZB
正确的写法:
SELECT MAX(CAST(ID AS INT)) AS ID FROM DCP_ZB
原因:id是char 类型,需要把char 类型转为int 进行比较