求一SQL语句，谢谢

Question

SQL> select  * from t1;NAME                      SCORE
-------------------- ----------
a                          1000
b                          2000
b                             0
d                         -1300
c                         -1000
e                         -2000已选择6行。SQL> select name,decode(sign(score),-1,score+1000,score) as score 
  2  from t1;NAME                      SCORE
-------------------- ----------
a                          1000
b                          2000
b                             0
d                          -300
c                             0
e                         -1000已选择6行。

Answer 1

select wlch_name,(case when wlch_score<0 then wlch_score+1000 else wlch_score end ) wlch_score from wlch_t1

Answer 2

一楼的可以，二楼的是T-sql语法。