CAST 变类型,如 SELECT CAST('12' AS int)

select distinct CAST(value as signed) valueprice,CAST(value as signed) valueid from app_coupon

原文地址:https://www.cnblogs.com/baijin05/p/5040253.html