select a.name,sum(datediff(minute,StartProcessDate,EndProcessDate))/60 as score
from T_Question b,T_QuestionType a
where a.id=b.qtid group by a.name having sum(datediff(minute,StartProcessDate,EndProcessDate))/60 <>0接着我又取余数
select a.name,sum(datediff(minute,StartProcessDate,EndProcessDate))%60 as score
from T_Question b,T_QuestionType a
where a.id=b.qtid group by a.name having sum(datediff(minute,StartProcessDate,EndProcessDate))%60 <>0
现在我想把分别求到的小时数,和分钟数连在一起,用点号,比如2.4代表20小时零4分怎么连接到一张表里显示出来,暴急啊,兄弟们
from T_Question b,T_QuestionType a
where a.id=b.qtid group by a.name having sum(datediff(minute,StartProcessDate,EndProcessDate))/60 <>0接着我又取余数
select a.name,sum(datediff(minute,StartProcessDate,EndProcessDate))%60 as score
from T_Question b,T_QuestionType a
where a.id=b.qtid group by a.name having sum(datediff(minute,StartProcessDate,EndProcessDate))%60 <>0
现在我想把分别求到的小时数,和分钟数连在一起,用点号,比如2.4代表20小时零4分怎么连接到一张表里显示出来,暴急啊,兄弟们
()aa
full join
()bb
On aa.name=bb.name
from
(select a.name,m=sum(datediff(minute,StartProcessDate,EndProcessDate))/60 as score
from T_Question b,T_QuestionType a
where a.id=b.qtid
group by a.name
having sum(datediff(minute,StartProcessDate,EndProcessDate))/60 <>0) t
innert join
(select a.name,s=sum(datediff(minute,StartProcessDate,EndProcessDate))%60 as score
from T_Question b,T_QuestionType a
where a.id=b.qtid
group by a.name
having sum(datediff(minute,StartProcessDate,EndProcessDate))%60 <>0) p
on t.[name]=p.[name]
from
(select a.name,m=sum(datediff(minute,StartProcessDate,EndProcessDate))/60 as score
from T_Question b,T_QuestionType a
where a.id=b.qtid
group by a.name
having sum(datediff(minute,StartProcessDate,EndProcessDate))/60 <>0) t
innert join
(select a.name,s=sum(datediff(minute,StartProcessDate,EndProcessDate))%60 as score
from T_Question b,T_QuestionType a
where a.id=b.qtid
group by a.name
having sum(datediff(minute,StartProcessDate,EndProcessDate))%60 <>0) p
on t.[name]=p.[name]
和这行有语法错误
(select a.name,s=sum(datediff(minute,StartProcessDate,EndProcessDate))%60 as score
消息 156,级别 15,状态 1
关键字 'as' 附近有语法错误。
消息 156,级别 15,状态 1
关键字 'as' 附近有语法错误。
1 BUG提交 12.59
2 跟新问题 104.21
3 解除绑定 609晕,汗
(
select a.name,sum(datediff(minute,StartProcessDate,EndProcessDate))/60 as score
from T_Question b,T_QuestionType a
where a.id=b.qtid group by a.name having sum(datediff(minute,StartProcessDate,EndProcessDate))/60 <>0
)aa
full join
(
select a.name,sum(datediff(minute,StartProcessDate,EndProcessDate))%60 as score
from T_Question b,T_QuestionType a
where a.id=b.qtid group by a.name having sum(datediff(minute,StartProcessDate,EndProcessDate))%60 <>0
)bb
On aa.name=bb.name
select a.name,ltrim(sum(datediff(minute,StartProcessDate,EndProcessDate))/60) +'.'+
ltrim(sum(datediff(minute,StartProcessDate,EndProcessDate))%60)
from T_Question b,T_QuestionType a
where a.id=b.qtid group by a.name