PUZZLEUP 2017

solomon_007 · 发表于 2017-9-8 11:32

改成按度数就OK了：

with t(n,h1,m1,s1,h2,m2,s2) as
(select 1,
      1 /3600*(1/12)*360       h1,
      mod(1 / 60, 60)/60 * 360  m1,
      mod(1, 60) / 60 *360    s1,

      1 / (50 * 60)*(1/12)*360  h2,
      mod(1 / 50, 60) / 60*360  m2,
      mod(1, 50) / 60*1.2*360 s2
from dual
  union all
  select t.n + 1,
      (t.n + 1) / 3600*(1/12)*360       h1,
      mod((t.n + 1) / 60, 60) / 60 *360    m1,
      mod((t.n + 1), 60) / 60 *360          s1,
      (t.n+1) / (50 * 60)*(1/12)*360  h2,
      mod(t.n+1 / 50, 60) / 60*360  m2,
      mod(t.n+1, 50) / 60*1.2*360 s2
from t
where not( abs(s1-s2) < 1 and abs(m1-h2) < 1) )
select numtodsinterval(max(n),'SECOND'),max(n) from t

solomon_007 · 发表于 2017-9-8 11:32

+000000000 03:20:00.000000000 12000

solomon_007 · 发表于 2017-9-8 11:34

newkid 发表于 2017-9-7 22:50
不会吧？难道不是200分钟吗？

根据OO的改成按角度的度数就可以了。。。唉，小学没毕业。。

lugionline · 发表于 2017-9-8 19:58

PL/SQL 把大学生变成小学生，MMA 让大学生变成博士生

newkid · 发表于 2017-9-8 21:09

lugionline 发表于 2017-9-8 19:58
PL/SQL 把大学生变成小学生，MMA 让大学生变成博士生

你到现在还没搞清楚PL/SQL和SQL的区别。

这个题的秒针每五分钟重合一次，所以求分钟数：
select (max(level)+1)*5 from dual connect by mod(360*5/60*level,360)<>mod(360*5/60/12*1.2*level,360);

solomon_007 · 发表于 2017-9-8 21:27

newkid 发表于 2017-9-8 21:09
你到现在还没搞清楚PL/SQL和SQL的区别。

这个题的秒针每五分钟重合一次，所以求分钟数：

呵呵，也只有你可以压一压lugionline的“嚣张”气焰

lugionline · 发表于 2017-9-8 21:38

newkid 发表于 2017-9-8 21:09
你到现在还没搞清楚PL/SQL和SQL的区别。

这个题的秒针每五分钟重合一次，所以求分钟数：

这题目谁不知道5分钟重合一次阿，看我第一个方程，你还可以直接Select 300 不是更简单

MMA 能自动推出合理的结论，节省大量脑细胞让你处理更复杂的问题

〇〇 · 发表于 2017-9-9 11:18

都存在题目不够的问题,所以pl/sql每日一题不容易

2 September 2017: Start of the new season
The new season will start Saturday, September 9th, 2017, 16:00 server time.
Last year it became challenging for the team to continue with the weekly publication scheme. Now that we have over 600 problems published, finding new and interesting problems is becoming increasingly difficult.
As long as we have a sufficient number of problems that are ready for publication then we are able to maintain a weekly release of new problems. However, we currently do not, so we have made a decision to reduce the release of new problems to one problem every two weeks. If we can re-establish enough ready-to-publish problems, then we will return to weekly publication.
As you are aware, many of the excellent problems that we have learned to enjoy have come about through the contributions of our members. If you have any interesting ideas for new problems, then please consider making a problem proposal. See Suggesting New Problems for more information on the process.

复制代码

lugionline · 发表于 2017-9-9 12:06

〇〇发表于 2017-9-9 11:18
都存在题目不够的问题,所以pl/sql每日一题不容易

你是那个冒泡？
friend key 是多少？

〇〇 · 发表于 2017-9-9 15:19

lugionline 发表于 2017-9-9 12:06
你是那个冒泡？
friend key 是多少？

我的答案很多都是抄的,有的是运行几天的程序才得出的

[每日一题] PUZZLEUP 2017