SELECT
ROW_NUMBER() over (order by a.lngCraneNo)as F,
a.lngCraneNo ,
a.strCraneName ,
b.strItemName_2 ,
c.strUnitName_2 ,
b.lngExchStand ,
d.lngChangeValue ,
case when isnull(b.lngExchStand,0)=0 then 0
else
d.lngChangeValue/b.lngExchStand end as E,
dtmCollectDate
FROM tblMaintenanceOriData as q left JOIN
BDataMaintenanceItem as b ON
q.lngCntUnitNo =b.lngCntUnitNo left JOIN
SysBldSystemInfoDefine as a on
a.lngItemNo = b.lngItemNo left JOIN
BInfoMaintItemUnitDefine as c ON
b.lngUnitNo = c.lngUnitNo left JOIN
tblMaintenanceHistory as d ON
a.lngGroupNo = d.lngGroupNo
group by a.lngCraneNo,a.strCraneName,b.strItemName_2,c.strUnitName_2 , b.lngExchStand ,d.lngChangeValue,dtmCollectDate
ROW_NUMBER() over (order by a.lngCraneNo)as F,
a.lngCraneNo ,
a.strCraneName ,
b.strItemName_2 ,
c.strUnitName_2 ,
b.lngExchStand ,
d.lngChangeValue ,
case when isnull(b.lngExchStand,0)=0 then 0
else
d.lngChangeValue/b.lngExchStand end as E,
dtmCollectDate
FROM tblMaintenanceOriData as q left JOIN
BDataMaintenanceItem as b ON
q.lngCntUnitNo =b.lngCntUnitNo left JOIN
SysBldSystemInfoDefine as a on
a.lngItemNo = b.lngItemNo left JOIN
BInfoMaintItemUnitDefine as c ON
b.lngUnitNo = c.lngUnitNo left JOIN
tblMaintenanceHistory as d ON
a.lngGroupNo = d.lngGroupNo
group by a.lngCraneNo,a.strCraneName,b.strItemName_2,c.strUnitName_2 , b.lngExchStand ,d.lngChangeValue,dtmCollectDate
解决方案 »
- 急,SQL题目
- 求教一条SQL语句的写法,关于时间段的
- 一个查询的问题
- 如何使用sp_executesql
- 关于cast/decimal
- 这条SQL语句在执行的时候 会不会有什么问题?请大侠们看看
- 请教大家下面SQL函数的意思
- 一个初级问题,数据"2003-10-31 13:17:11"和数据"2003-10-31 "应该如何比较?
- 知道触发器名字,怎样获得它创建时的SQL?
- 现有sqlserver7.0的数据文件(.mdf和.ldf),请问有恩有办法使它在sqlserver2000下运行
- sql-access excel的相关语法
- 插入Text类型数据中既有单引号又有双引号时会出错,有什么办法处理吗?
把row_number() 用count()来计算 可能行。