sql小结

1.取1-10 

select  Id from (select a.Id,row_number() over(order by order_Date) rn from table1 a left join  table2 b on a.=b.
left join c on a.=c. left join d on a.=d.where ...) where rn between 1 and 10

2.主表全部列出来

select T1.ID AS ID
from table1 T1 ,table2 T2 where T2.ID(+) ='1111111111'and T1.FLAG = T2.FLAG(+) ; 

3.日期转换

 select to_char(m1.LOGON_TIME,'yyyy-mm-dd hh24:mi:ss') from m1
    where to_char(m1.LOGON_TIME,'yyyyMMdd')='20180715' order by m1.logon_time desc

4. 当前系统日期

to_char(b.create_time,'yyyymmddhh24mi')=（  select to_char(sysdate,'yyyymmddhh24mi') from dual）