sql 问题关于公式计算的挑战

Question

declare 
	@M decimal(18,2)
	set @M=18.5;
with Configer as(
select 'code1'as code,'M>21&M<65' as configer
union
select 'code2'as code,'M<=30' as configer
union
select 'code3'as code,'M*10<=200' as configer
union
select 'code4'as code,'M-10>15' as configer
union
select 'code5'as code,'(M-10)*5>10' as configer
union
select 'code6'as code,'M=18.5' as configer
)

	select code,REPLACE(REPLACE(configer,'M',convert(varchar(20),@M)),'&',' and ') as Formula from Configer



	





	除了循环之外 有没有其他方式可以直接获取出公式满足的结果集？



	

Answer 1

我的代码怎么除了那么多P 还会出来br