oracle使用with语法可以提高查询效率
select * from(with tdate as(select trunc(sysdate)-level aa from dualconnect by level <2000)select a.aa,b.aa bfrom tdate a,tdate bwhere a.aa=b.aa)
?
