该SQL查询用于找出过去七天中数据库表空间TS_TO_ORDER的每日增量最大值。它首先为每一天添加序列号，然后通过两个子查询的JOIN操作找出自由空间的最大差异。
取去前七天里面，每天增量最大的值
首先要给表中每列加个序列号，然后利用2个表数据序号差，查出每天的增量数据
SELECT MAX(A.FREE -B.FREE) MAX_CC FROM
(SELECT
TOP 10
ROW_NUMBER () OVER (ORDER BY DAY) IDX,
DAY,
FREE
FROM
DB_TABLESPACE_USED_HIS
WHERE
DB_ID = '1530706841'
AND TABLESPACE_NAME = 'TS_TO_ORDER'
AND DAY > CONVERT (
VARCHAR (10),
GETDATE() - 8,
120
)
ORDER BY DAY ASC) A
LEFT JOIN
(SELECT
TOP 10
ROW_NUMBER () OVER (ORDER BY DAY) IDX,
DAY,
FREE
FROM
DB_TABLESPACE_USED_HIS
WHERE
DB_ID = '1530706841'
AND TABLESPACE_NAME = 'TS_TO_ORDER'
AND DAY > CONVERT (
VARCHAR (10),
GETDATE() - 7,
120
)
ORDER BY DAY ASC) B ON A.IDX=B.IDX
扫一扫
1343
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
