首页 > 代码库 > dual oracle 虚表

dual oracle 虚表

select rownum, t3.*  from (select count(*)          from (select *                  from TRIPINFO t                 where t.starttime between 20130905001339 and 20130905202651) t2         group by t2.starthour         order by t2.starthour) t3  from dual

 

dual oracle 虚表