sqllite 在语句中进行数据类型转换

select CODE,SNAME ,AMOUNT_TOTAL,AMOUNT_USE,PRICE from holding_s where CAST(substr(AMOUNT_TOTAL,1,3) as int) >0

 

 

CAST     STR   AS INT