观察如下的算式:
9213 x 85674 = 789314562
左边的乘数和被乘数正好用到了1~9的所有数字,每个1次。
而乘积恰好也是用到了1~9的所有数字,并且每个1次。
请你借助计算机的强大计算能力,找出满足如上要求的9数算式
WITH ct
AS
(
SELECT CONVERT(VARCHAR(1),number) AS number FROM master..spt_values WHERE type='P' AND number BETWEEN 1 AND 9
)
SELECT a.number+b.number+c.number+d.number+e.number+f.number+g.number+h.number+i.number AS A INTO #Tmp FROM ct a ,ct b ,ct c,ct d,ct e,ct f,ct g,ct h,ct i
WHERE
a.number <>b.number AND a.number<>c.number AND a.number<>d.number AND a.number<>e.number AND a.number<>f.number AND a.number<>g.number AND a.number<>h.number AND a.number<>i.number AND
b.number<>c.number AND b.number<>d.number AND b.number<>e.number AND b.number<>f.number AND b.number<>g.number AND b.number<>h.number AND b.number<>i.number AND
c.number<>d.number AND c.number<>e.number AND c.number<>f.number AND c.number<>g.number AND c.number<>h.number AND c.number<>i.number AND
d.number<>e.number AND d.number<>f.number AND d.number<>g.number AND d.number<>h.number AND d.number<>i.number AND
e.number<>f.number AND e.number<>g.number AND e.number<>h.number AND e.number<>i.number AND
f.number<>g.number AND f.number<>h.number AND f.number<>i.number AND
g.number<>h.number AND g.number<>i.number AND
h.number<>i.number
SELECT * FROM
(
SELECT SUBSTRING(A,1,B.number) AS X,SUBSTRING(A,number+1,9) AS Y,CONVERT(VARCHAR(20),CONVERT(INT,SUBSTRING(A,1,B.number))*CONVERT(INT,SUBSTRING(A,number+1,9))) AS Z
FROM #tmp A ,(SELECT number FROM master..spt_values WHERE type='P' AND number BETWEEN 1 AND 4 ) B
) B
WHERE
z NOT LIKE '%0%'
AND z NOT LIKE '%1%1%'
AND z NOT LIKE '%2%2%'
AND z NOT LIKE '%3%3%'
AND z NOT LIKE '%4%4%'
AND z NOT LIKE '%5%5%'
AND z NOT LIKE '%6%6%'
AND z NOT LIKE '%7%7%'
AND z NOT LIKE '%8%8%'
AND z NOT LIKE '%9%9%'
AND LEN(Z)=9
DROP TABLE #Tmp