求一sql语句

Question

select shuzhi=round(if(shuzhi>550,shuzhi-100,shuzhi-50),0) from A是这个样子的

Answer 1

select shuzhi=round(if(shuzhi>550,shuzhi-100,shuzhi-50),0) from A是这个样子的

Answer 2

select shuzhi=round(if(shuzhi>550,shuzhi-100,shuzhi-50),0) from A是这个样子的

Answer 3

select shuzhi=round(case when shuzhi>550 then shuzhi-100 else shuzhi-50 end,0) from gz 

Answer 4

select (case when shuzhi  >550 then  shuzhi-100
case when shuzhi<=550 rhen shuzhi-50
else  shuzhi
) 'Result'from Tables

Answer 5

declare @t table(id int,   shuzhi  dec(9,2))
insert @t select 1,523.36
insert @t select 2,536.24
insert @t select 3,652.36
insert @t select 4,785.98select shuzhi=ceiling(round(case when shuzhi>550 then shuzhi-100 else shuzhi-50 end,0)) from @tshuzhi
---------------------------------------
473
486
552
686(4 行受影响)

Answer 6

select round((case when shuzhi>550 then shuzhi-100 else shuzhi-50 end),0) from gz