Darcy的博客

sqlite的case函数是用来做类型的强制转换的语法： cast(col_name as type)例如：select MAX(cast(POINT_NM as int)) as POINT_NM from POINT表数据如下：POINT_NM|POINT_ID3 | 14 | 2tt | 36 | 4运行例句，获得以下结果：POINT_NM6...

直接+0判断即可。select * from table where col+0=col;例如，表内容如下： POINT_NM|POINT_ID 5 | 1 6 | 2 7tt | 3取得最大的POINT_NM值，要求是整型，sqlite语句如下：select MAX(cast(POINT_NM as int)) as POINT_NM from POINTwhe...