您的位置:首页 > 博客中心 > 数据库 >

dual oracle 虚表

时间:2022-03-14 04:08

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

 

热门排行

今日推荐

热门手游