论坛: 编程破解 标题: 查一天中最大湿度的SQL语句（原创） 复制本贴地址    
作者: SCANDISK [scandisk]    论坛用户   登录
SELECT
`a`.`devtime` AS `devtime`,
`a`.`terminalname` AS `terminalname`,
`a`.`humidity` AS `humidity`
FROM
(
`lbclient`.`data_home` `a`
JOIN (
SELECT
cast(
`lbclient`.`data_home`.`devtime` AS date
) AS `devtime`,
`lbclient`.`data_home`.`terminalname` AS `terminalname`,
max(
`lbclient`.`data_home`.`humidity`
) AS `humidity`
FROM
`lbclient`.`data_home`
WHERE
(
(
`lbclient`.`data_home`.`terminalname` LIKE '%中药库18%'
)
AND (
`lbclient`.`data_home`.`devtime` > '2021-07-07 00:00:00'
)
AND (
`lbclient`.`data_home`.`devtime` < curdate()
)
)
GROUP BY
cast(
`lbclient`.`data_home`.`devtime` AS date
)
HAVING
(
max(
`lbclient`.`data_home`.`humidity`
) > 70
)
ORDER BY
`devtime`
) `b`
)
WHERE
(
(
cast(`a`.`devtime` AS date) = `b`.`devtime`
)
AND (
`a`.`humidity` = `b`.`humidity`
)
AND (
`a`.`terminalname` LIKE '%中药库18%'
)
AND (
`a`.`devtime` > '2021-7-7 00:00:00'
)
AND (`a`.`devtime` < curdate())
AND (`a`.`humidity` > 70)
)
ORDER BY
`a`.`devtime`

//查询一天中最大湿度的SQL语句，为湿度调控决策做依据。

地主 发表时间: 21-09-13 08:14

论坛: 编程破解

20CN网络安全小组版权所有
Copyright © 2000-2010 20CN Security Group. All Rights Reserved.
论坛程序编写：NetDemon

粤ICP备05087286号