九数算式-SQL Server

观察如下的算式:
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  

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值