sql 保留小数+四舍五入

最新推荐文章于 2024-05-25 12:32:03 发布

ole_triangle_java

最新推荐文章于 2024-05-25 12:32:03 发布

阅读量335

点赞数

分类专栏：公司内部用

本文链接：https://blog.csdn.net/ole_triangle_java/article/details/80923259

版权

公司内部用专栏收录该内容

28 篇文章

订阅专栏

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