有方法显示分摊后的每层面积吗

时间：2020-08-18 16:55 作者：狂野小菜鸟阅读：1041 评论：1

其他

from clipboard

23层为一层的附属

有办法显示每层的分摊后的建筑面积吗，不要一层显示总面积

全部评论

等级:LV28

积分:55758

南方数码蓉儿 2020-08-19 08:58

SELECT shisFloors.FloorName,shisFloors.FloorNo, fthlcmj.jzmj,fthlcmj.tnmj,fthlcmj.jzmj-fthlcmj.tnmj as ftmj,fthlcmj.ytmj from shisBuildInf inner join shisFloors on shisFloors.buildingid=shisBuildInf.id

right join

(SELECT Flrid, SUM(ROUND(tnmj, 2)) AS tnmj, SUM(ROUND(zmj, 2)) AS jzmj, SUM(ROUND(ytmj, 2)) AS ytmj,SUM(tnmj) AS tn,SUM(ftmj) AS ft FROM viewBmfRoom2 GROUP BY Flrid) fthlcmj on fthlcmj.Flrid=shisFloors.id

where shisBuildInf.id=[BUILDID]order by shisFloors.FloorNo

这个语句是按分摊后2位数的户室面积来计算的楼层面积。