oracle通过年、月两个条件查询数据库数据

SELECT

wqb.STNM, wqd.STCD, wqd.SPT, wqd.WT, wqd.PH, wqd.COND, wqd.TURB, wqd.DOX,

wqd.CODMN, wqd.CODCR, wqd.TN, wqd.NH3N, wqd.NO2, wqd.NO3, wqd.TP, wqd.TOC, wqd.F,

wqd.ARS, wqd.HG, wqd.CR6, wqd.CU, wqd.PB, wqd.CD, wqd.ZN, wqd.SB, wqd.TS, wqd.NT

FROM

WQ_AWQMSINF_B wqb

inner JOIN

WQ_AWQMD_D wqd

ON wqb.STCD = wqd.STCD

and wqb.STCD = '30909200'

--and (to_char(wqd.SPT,'YYYY-MM') in ('2013-06','2014-06','2015-06'))

--and to_char(wqd.SPT,'YYYY') >= '2011' and to_char(wqd.SPT,'YYYY') <= '2015' and to_char(wqd.SPT,'MM')='06'

and EXTRACT(YEAR FROM wqd.SPT) >= '2011' and EXTRACT(YEAR FROM wqd.SPT) <= '2015' and EXTRACT(MONTH FROM wqd.SPT)='06'

ORDER BY wqd.SPT ASC