--1.查询某一日期内某天最大的数据量 select date(TS_UPDATE) as time,count(2) as 数量 from tableInfo where date(TS_UPDATE) between '2010-04-01' and '2013-05-01' group by date(TS_UPDATE) order by 2 desc FETCH FIRST 1 ROWS ONLY --2.查询数据量大大天的具体时间点的最大数据量,意思就是改天最大时间点最大数据量 SELECT SUBSTR(TO_CHAR(TS_UPDATE,'YYYY-MM-DD HH24:MI:SS'),1,10) AS DATE,SUBSTR(TO_CHAR(TS_UPDATE,'YYYY-MM-DD HH24:MI:SS'),11,3) AS TIME, COUNT(2) AS NUM FROM tableInfo WHERE DATE(TS_UPDATE) between ( select newTable.time from ( select date(TS_UPDATE) as time,count(2) as 数量 from tableInfo where date(TS_UPDATE) between '2010-04-01' and '2013-05-01' group by date(TS_UPDATE) order by 2 desc FETCH FIRST 1 ROWS ONLY ) as newTable ) and ( select newTable.time from ( select date(TS_UPDATE) as time,count(2) as 数量 from tableInfo where date(TS_UPDATE) between '2010-04-01' and '2013-05-01' group by date(TS_UPDATE) order by 2 desc FETCH FIRST 1 ROWS ONLY ) as newTable ) GROUP BY SUBSTR(TO_CHAR(TS_UPDATE,'YYYY-MM-DD HH24:MI:SS'),1,10), SUBSTR(TO_CHAR(TS_UPDATE,'YYYY-MM-DD HH24:MI:SS'),11,3) ORDER BY 2 DESC FETCH FIRST 1 ROWS ONLY
转载于:https://www.cnblogs.com/weinan2087/p/DB2%e6%95%b0%e6%8d%ae%e5%ba%93SQL%e7%bb%8f%e5%85%b8%e6%9f%a5%e8%af%a2.html