sql 保留小数+四舍五入

关注

原创最新推荐文章于 2026-03-24 00:21:47 发布 438 阅读 AI 写同款· GEO 优化 ›

星网锐捷语音网关密码重置恢复出厂设置星网锐捷语音网关---密码重置第一种星网锐捷SVX网关恢复出厂设置的方法 eth1口任意口插网线，连接电脑并设置电脑固定ip为：一，二网页输入： 192.168.88.86 admin 默认密码 admin 登陆。忘记密码可通过以下方法重置：三：通过crt或者 shell工具 ,连接 root@192.168.88.86 连续输入两次 passwd a12345678 reboot重启后。通过账号密码 a12345678 即可登陆系... 阅读详情

SELECT  sampleInStockTable.CN_ID AS primaryId,
	sampleInStockTable.CN_NO AS no,
	salesTable.CN_NO AS salesTableNo,
article.CN_NO AS articleNo,
sampleInStockTable.CN_REAL_INSTOCK_DATE AS realInstockDate,
stuser.CN_NAME AS userInfoCheck,
sum(sampleInStockLine.CN_LEFT_IN_STOCK_QTY) AS leftStockQty,
sum(sampleInStockLine.CN_RIGHT_IN_STOCK_QTY) AS rightStockQty,
Round(convert(float,(sum(sampleInStockLine.CN_LEFT_IN_STOCK_QTY) + sum(sampleInStockLine.CN_RIGHT_IN_STOCK_QTY)))/convert(float,2),1) AS instockQty
 FROM 
TC_SAMPLE_IN_STOCK_TABLE AS sampleInStockTable
INNER JOIN TN_SALES_TABLE AS salesTable ON sampleInStockTable.CR_SALES_TABLE_ID = salesTable.CN_ID
INNER JOIN TN_ARTICLE AS article ON article.CN_ID = sampleInStockTable.CR_ARTICLE_ID
INNER JOIN ST_USER AS stuser ON stuser.CN_ID = sampleInStockTable.CR_USER_INFO_CHECK
LEFT JOIN TC_SAMPLE_IN_STOCK_LINE AS sampleInStockLine ON sampleInStockTable.CN_ID = sampleInStockLine.CR_SAMPLE_IN_STOCK_TABLE_ID
WHERE #salesTable.CN_NO LIKE '%[salesNo]%'
 AND #sampleInStockTable.CN_NO LIKE '%[no]%' 
AND (#sampleInStockTable.CN_REAL_INSTOCK_DATE BETWEEN [realInstockDate_START] AND [realInstockDate_END])
GROUP BY  sampleInStockTable.CN_ID,sampleInStockTable.CN_NO,salesTable.CN_NO,article.CN_NO,sampleInStockTable.CN_REAL_INSTOCK_DATE,stuser.CN_NAME 
ORDER BY sampleInStockTable.CN_NO asc 
OFFSET [maxRowNumber] ROWS FETCH NEXT [onePageDataNumber] ROWS ONLY

收录于