一些有用的sql备忘:
关于日期时间:
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual --当前时间
union all
select to_char(sysdate-1-1/24-1/24/60-1/24/60/60 ,'yyyy-mm-dd hh24:mi:ss') from dual
从多少条到多少条查询 :
①
select * from table where rownum<20
minus
select * from table where rownum<10
②
select * from (select rownum r,a.* from blog a where rownum<=20) where r>=10;
②的效率高于①