SELECT COUNT(IN_DATE) AS SITE_NAME FROM (SELECT (TO_DATE('2020-05-15 23:59:00', 'YYYY-MM-DD HH24:MI:SS') + (LEVEL/24/60)) AS IN_DATE FROM DUAL CONNECT BY LEVEL/24/60 <= TO_DATE('2020-05-16 17:05:00', 'YYYY-MM-DD HH24:MI:SS') - TO_DATE('2020-05-16 00:00:00', 'YYYY-MM-DD HH24:MI:SS')) WHERE IN_DATE NOT IN (SELECT MESR_TM FROM HMI_DATA WHERE MESR_TM >= TO_DATE('2020-05-16 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TAG_ID = 'SITE_NAME_Flow2_Total_Flow') ORDER BY IN_DATE ASC ;
오라클 쿼링ㄴ데
mssql로 바꿀려면 어떻게 해야하나뇨..
|