趣题, 第8道来了。

ei0123 · 发表于 2013-7-18 15:23

SQL> with t as (select rownum,to_char(trunc(sysdate)+rownum/1440,'hh:mi') as time,mod(rownum*6,360) as mi,trunc(rownum/12)*6 as hh from dual connect by rownum<721)
  2    select a.time,a.hh,a.mi,b.time from t a,t b where a.mi=b.hh and a.hh=b.mi order by a.time;

TIME       HH       MI TIME
----- ---------- ---------- -----
01:00       30       0 12:05
01:05       30       30 01:05
01:10       30       60 02:05
01:15       36       90 03:06
01:20       36       120 04:06
01:25       42       150 05:07
01:30       42       180 06:07
01:35       42       210 07:07
01:40       48       240 08:08
01:45       48       270 09:08

三市白 · 发表于 2013-8-14 16:19

mark BD

[精华] 趣题, 第8道来了。