发现一位专门用SQL解各种谜题的高人！

kochia

强人！

juan025

newkid 发表于 2010-6-25 00:52
http://oraqa.com/2010/06/08/how-to-solve-the-multiple-dwellings-puzzle-in-sql/#comment-1000

How t ...

1. SELECT *
2.   FROM (SELECT ROWNUM AS BAKER FROM DUAL CONNECT BY ROWNUM < 6) A,
3.        (SELECT ROWNUM AS COOPER FROM DUAL CONNECT BY ROWNUM < 6) B,
4.        (SELECT ROWNUM AS FLETCHER FROM DUAL CONNECT BY ROWNUM < 6) C,
5.        (SELECT ROWNUM AS MILLER FROM DUAL CONNECT BY ROWNUM < 6) D,
6.        (SELECT ROWNUM AS SMITH FROM DUAL CONNECT BY ROWNUM < 6) E
7. WHERE BAKER <> COOPER
8.    AND BAKER <> FLETCHER
9.    AND BAKER <> MILLER
10.    AND BAKER <> SMITH
11.    AND COOPER <> FLETCHER
12.    AND COOPER <> MILLER
13.    AND COOPER <> SMITH
14.    AND FLETCHER <> MILLER
15.    AND FLETCHER <> SMITH
16.    AND MILLER <> SMITH
17.    AND BAKER <> 5
18.    AND COOPER <> 1
19.    AND FLETCHER <> 1
20.    AND FLETCHER <> 5
21.    AND ABS(SMITH - FLETCHER) <> 1
22.    AND ABS(FLETCHER - COOPER) <> 1
23.    AND MILLER > COOPER;

复制代码

这也可以，笨了点

bin_wind

留名，学习

zoujb1314

离大神之路真的好艰辛

kelis2004

除了膜拜还是膜拜

oracle_cj

刚才不小心点了进去看了下，很多系统包都没用过，你们牛逼的不行。我还停留在初级水平啊。

desert_xu

怎么变成日本网站了？