ORCLE行转列写法

select * from 
(select t1.dt_mc, to_char(t.rq, 'yyyymmdd')yf,nvl(count(*),0)qhl
  from dt_gkjl_gkjlls t, dt_jbxx t1
 where t.DT_DM = t1.dt_dm
 and t.RQ>=to_date('20170601','yyyymmdd')
 group by t1.dt_mc, to_char(t.rq, 'yyyymmdd'))
 pivot ( sum(qhl)  for yf in (20170601 rq,20170602 sj2,20170605 sj5 ) );