强哥的博客

select xxx,case when T.ELUDEMONEYTYPEITEM=901 then cast('901' as varchar2(20)) else cast((SELECT COUNT (*) FROM JC_EVADETOLL_RECORD rd WHERE rd.JCFUNID = T .RE

select id,name from table group by zuming :mysql可以实现select id,name,zuming from table group by zuming :oracle实现方式 你的组名必须体现在查询的条件里（你连组名都没有查询 怎么可以用组名查询）

select  date'2017-01-01' + (rownum - 1) curdate  from  dual connect by rownum <= (sysdate - date'2017-01-01' + 1)