소통정보제보.sql 251 B

123456789
  1. SELECT LINK_ID, CRTN_DT,
  2. APLY_STRT_DT, APLY_END_DT,
  3. NVL(TFVL, 0) AS TFVL,
  4. NVL(SPED, 0) AS SPED,
  5. NVL(OCPY_RATE, 0) AS OCPY_RATE,
  6. NVL(TRVL_HH, 0) AS TRVL_HH
  7. FROM TB_LINK_SYOP_TRAF
  8. ORDER BY 1, 2