mysql 以查询结果作为查询条件sql写法
SELECTdor.DEVICE_UUID AS deviceUuid,dor.OUTAGE_START AS outageStart,dor.OUTAGE_END AS outageEnd,dor.outageTime AS outageTimeFROM(SELECTDEVICE_UUID,OUTAGE_START,OUTAGE_END,CASEW
·
SELECT
dor.DEVICE_UUID AS deviceUuid,
dor.OUTAGE_START AS outageStart,
dor.OUTAGE_END AS outageEnd,
dor.outageTime AS outageTime
FROM
(
SELECT
DEVICE_UUID,
OUTAGE_START,
OUTAGE_END,
CASE
WHEN OUTAGE_END IS NULL THEN
0
ELSE
(
UNIX_TIMESTAMP(OUTAGE_END) - UNIX_TIMESTAMP(outage_start)
) / 60
END outageTime
FROM
device_outage_record
WHERE
DEVICE_UUID = 'b8e2b24734ff494290d332964c749809'
AND OUTAGE_END IS NOT NULL
) AS dor
WHERE
dor.outageTime > 12
更多推荐
已为社区贡献2条内容
所有评论(0)