<p>---查询7天的数据</p><p><br></p><p>select&nbsp;</p><p>&nbsp;a.today as "day",</p><p>&nbsp;&nbsp;nvl(b.general,0) as "general",</p><p>&nbsp;&nbsp;nvl(b.larger,0) as "larger",</p><p>&nbsp;&nbsp;nvl(b.great,0) as "great",</p><p>&nbsp;&nbsp;nvl(b.most,0) as "most"</p><p>FROM&nbsp;</p><p>(SELECT&nbsp;</p><p>&nbsp;&nbsp;to_char (SYSDATE- LEVEL + 1, 'yyyy-mm-dd') today</p><p>&nbsp;FROM</p><p>&nbsp;&nbsp;DUAL connect BY LEVEL &lt;= 7) a</p><p>LEFT JOIN&nbsp;</p><p>&nbsp;&nbsp;(&nbsp;&nbsp;select to_char(t.CREATE_TIME_,'YYYY-MM-dd') as day,</p><p>&nbsp;&nbsp;SUM(CASE t.LEVEL_ WHEN '1' THEN 1 ELSE 0 END) AS general,</p><p>&nbsp;&nbsp;SUM(CASE t.LEVEL_ WHEN '2' THEN 1 ELSE 0 END) AS larger,</p><p>&nbsp;&nbsp;SUM(CASE t.LEVEL_ WHEN '3' THEN 1 ELSE 0 END) AS great,</p><p>&nbsp;&nbsp;SUM(CASE t.LEVEL_ WHEN '4' THEN 1 ELSE 0 END) AS most</p><p>&nbsp;&nbsp;&nbsp;from QUALITY_PROBLEM t&nbsp;</p><p>&nbsp;&nbsp;WHERE&nbsp;t.project_id_ = '119993794937487360'&nbsp;</p><p>&nbsp;GROUP BY to_char(t.CREATE_TIME_,'YYYY-MM-dd')) b on a.today=b.day order by a.today</p><p><br></p>