SQL笔试题

Posted by 道行尚浅 on January 13, 2018

题目:已知 “ab”+’ab’=’bcc’ 求a,b,c的值


SQL> with v  as (select level c from dual connect by level<=100)
  2  select v1.c a ,v2.c b, v3.c c
  3   from v v1, v v2 ,v v3
  4  where (v1.c||v2.c )= to_number(v2.c||v3.c||v3.c)/2 ;

         A          B          C
---------- ---------- ----------
         6          1          2
        11         22          4
        12          2          4
        18          3          6
        22         44          8
        24          4          8
        30         61          2
        41         83          6

8 rows selected