查询sql保留小数去除小数点后面多余的0 

select TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM ROUND(sum(FIRM_QTY),5))) resfirmQty from ldc_stock

 

posted @ 2024-01-08 17:42  薛柏梁  阅读(59)  评论(0)  编辑  收藏  举报