수집원별 수집건수.sql 416 B

12345678910
  1. SELECT A.PRCN_DT, A.CLCT_SYST_CD, B.CLCT_SYST_NM, A.CLCT_NUM, A.FLTR_NUM, A.FUSN_NUM
  2. FROM TB_CLCT_SYST_STTS_HS A,
  3. TB_CLCT_SYST_STUP B
  4. WHERE A.PRCN_DT = (SELECT MAX(PRCN_DT)
  5. FROM TB_CLCT_SYST_STTS_HS
  6. WHERE PRCN_DT >= TO_CHAR(SYSDATE - 1/24, 'YYYYMMDDHH24MISS')
  7. )
  8. AND B.CLCT_SYST_CD = A.CLCT_SYST_CD(+)
  9. AND B.USE_YN = 'Y'