distinct 应该放在哪?
select ur.yhzmc,u.ym,u.yhm,u.lxdh,u.dzyj,u.yhmqc,u.szdw,u.ssbm,u.sfsd,u.yhbs,u.yhmm,u.fwsd,u.sjksq,to_char(u.fwkssj,'yyyy-mm-dd hh24:mi:ss') as fwkssj,to_char(u.fwjssj,'yyyy-mm-dd hh24:mi:ss') as FWJSSJ
from sys_user02 u,sys_user05 ur
where u.ym=ur.ym and u.yhm=ur.yhm(+) and sfsd!='-1'
order by ym,yhm distinct
select ur.yhzmc,u.ym,u.yhm,u.lxdh,u.dzyj,u.yhmqc,u.szdw,u.ssbm,u.sfsd,u.yhbs,u.yhmm,u.fwsd,u.sjksq,to_char(u.fwkssj,'yyyy-mm-dd hh24:mi:ss') as fwkssj,to_char(u.fwjssj,'yyyy-mm-dd hh24:mi:ss') as FWJSSJ
from sys_user02 u,sys_user05 ur
where u.ym=ur.ym and u.yhm=ur.yhm(+) and sfsd!='-1'
order by ym,yhm distinct
但你选择多列时，它是多列都相同的去掉