错误示例

select  PMId,GJTypeId,GJXHCode,GJMonomer,GJFloor,GJLong,GJWidth,GJHigh, convert(decimal(18,4),GJFL) AS GJFL,count(1) GJSum from GJ_ProjectGJ 
where PMId=2155 and GJMonomer=\'4#\' and GJXHCode=\'YB48.24.1\' 
group by PMId,GJTypeId,GJXHCode,GJMonomer,GJFloor,GJLong,GJWidth,GJHigh,GJFL

正确示例

select  PMId,GJTypeId,GJXHCode,GJMonomer,GJFloor,GJLong,GJWidth,GJHigh, convert(decimal(18,4),GJFL) AS GJFL,count(1) GJSum from GJ_ProjectGJ 
where PMId=2155 and GJMonomer=\'4#\' and GJXHCode=\'YB48.24.1\' 
group by PMId,GJTypeId,GJXHCode,GJMonomer,GJFloor,GJLong,GJWidth,GJHigh,convert(decimal(18,4),GJFL)

 一点小差池，会导致显示的数据出现问题

版权声明：本文为LessIsMoreZ原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/LessIsMoreZ/p/9675287.html