SELECT name, COUNT(id) AS c, SUM(IF (DATEDIFF(n, server_date,
server_finish_date) > 240 THEN ww = 240 ELSE ww = (DATEDIFF(n, server_date,
server_finish_date)) AS mm
FROM workrecord
GROUP BY name
ORDER BY mm我想实现当(DATEDIFF(n, server_date, server_finish_date) > 240
就按240来求和,如果小于就用DATEDIFF(n, server_date, server_finish_date)来求和请高手指教,如何实现,谢谢!!
server_finish_date) > 240 THEN ww = 240 ELSE ww = (DATEDIFF(n, server_date,
server_finish_date)) AS mm
FROM workrecord
GROUP BY name
ORDER BY mm我想实现当(DATEDIFF(n, server_date, server_finish_date) > 240
就按240来求和,如果小于就用DATEDIFF(n, server_date, server_finish_date)来求和请高手指教,如何实现,谢谢!!
解决方案 »
- SQL SERVER 2005
- SQL的语法不支持中文
- .net2003+sql2000,应用程序启动后,断网再连接上,执行sql语句异常
- 大型网站的数据库问题,请教各位
- 一个储存过程的问题``请大家帮帮忙
- 在vista home basic下装了sql server2005企业版无服务器可用要怎么办!
- 安装SQL时出现的问题,请指教,急等答案
- 创建新数据源 sql server和sql native client 有什么区别?
- ~~~~~~~~~~~~这样如何实现~~~~~~~~~~~~~~~~~~~~~~~~
- 在delphi 中有关数据库的问题
- re
- SQL执行错误,请大虾们帮看看 在下先谢过了
server_finish_date) > 240 THEN 240 ELSE (DATEDIFF(n, server_date,
server_finish_date)) AS mm
FROM workrecord
GROUP BY name
ORDER BY mm
SUM(case when DATEDIFF(n,server_date,server_finish_date)>240 THEN 240 ELSE DATEDIFF(n,server_date,server_finish_date)) AS mm
FROM workrecord
GROUP BY name
ORDER BY mm
FROM workrecord
GROUP BY name
ORDER BY mm
SELECT name,
COUNT(id) AS c,
SUM(case when DATEDIFF(n,server_date,server_finish_date) > 240 THEN 240 ELSE DATEDIFF(n,server_date,server_finish_date) end) AS mm
FROM workrecord
GROUP BY name
ORDER BY mm
SUM(case when DATEDIFF(n,server_date,server_finish_date)>240 THEN 240 ELSE DATEDIFF(n,server_date,server_finish_date ) end) AS mm
FROM workrecord
GROUP BY name
ORDER BY mm