腾讯公司费解的sql面试题，都来看看，留下你的见解

都是马后炮，还是最早那位用sql解出来的大哥猛！

 create table n_table (n int)  -- n 为 0..9

select a.n, b.n, c.n
from n_table a, n_table b, n_table c
where 11 * (a.n + b.n + c.n) = a.n * 100 + b.n * 10 + c.n 

让我想起一句经典批评用语：事后诸葛亮，事前猪一样~

例子：11+99+88=198，求满足这样要求的数,1,9,8等等~

select t1.x, t2.x, t3.x from

(select 0 x from dual union select 1 x from dual union select 2 x from dual union select 3 x from dual union select 4 x from dual union select 5 x from dual union select 6 x from dual union select 7 x from dual union select 8 x from dual union select 9 x from dual) t1,

(select 0 x from dual union select 1 x from dual union select 2 x from dual union select 3 x from dual union select 4 x from dual union select 5 x from dual union select 6 x from dual union select 7 x from dual union select 8 x from dual union select 9 x from dual) t2,

(select 0 x from dual union select 1 x from dual union select 2 x from dual union select 3 x from dual union select 4 x from dual union select 5 x from dual union select 6 x from dual union select 7 x from dual union select 8 x from dual union select 9 x from dual) t3

where t1.x*10+t1.x+t2.x*10+t2.x+t3.x*10+t3.x=t1.x*100+t2.x*10+t3.x

语法也许有错误，逻辑上是这个意思，用穷举法解决问题

三个表，都各有0到9共计10个数字，10条记录
关联查询三个表，尝试1000种组合，where条件就是题目中要求的条件。符合条件的所有3个数字的组合会被select语句查询出来

 create table n_table (n int)  -- n 为 0..9

select a.n, b.n, c.n
from n_table a, n_table b, n_table c
where 11 * (a.n + b.n + c.n) = a.n * 100 + b.n * 10 + c.n 

 create table n_table (n int)  -- n 为 0..9

select a.n, b.n, c.n
from n_table a, n_table b, n_table c
where 11 * (a.n + b.n + c.n) = a.n * 100 + b.n * 10 + c.n 

 create table n_table (n int)  -- n 为 0..9

select a.n, b.n, c.n
from n_table a, n_table b, n_table c
where 11 * (a.n + b.n + c.n) = a.n * 100 + b.n * 10 + c.n