我试图建立一个基本的报表功能。
表包含如下的基本列
ID,时间戳,值,键,查询,JSON
唯一的标识符在键列
有50万行
我想让它报告这个
SELECT min(value) as begin, max(value) as end FROM `key`WHERE NAME='Key1'
TIMERANGE='LastMonth'
有人可以帮助这个语法或我缺少的概念谢谢,非常感谢
试试这个
SELECT min(value) as begin, max(value) as end FROM `key`
WHERE NAME='Key1' and
timestamp>=date_add(current_date(),interval -1 month) and timestamp<=current_date()
SELECT min(value) as begin, max(value) as end FROM `key`
WHERE ID='Key1'
AND timestamp >= DATEADD(month, DATEDIFF(month, -1, getdate()) - 2, 0)
AND timestamp <= DATEADD(ss, -1, DATEADD(month, DATEDIFF(month, 0, getdate()), 0))
或
SELECT ID, min(value) as begin, max(value) as end FROM `key`
WHERE timestamp >= DATEADD(month, DATEDIFF(month, -1, getdate()) - 2, 0)
AND timestamp <= DATEADD(ss, -1, DATEADD(month, DATEDIFF(month, 0, getdate()), 0))
GROUP BY ID