求一SQL，根据条件查询数据

[barysacc880]

表结构

id newNumber oldNumber
1001 1 null
1002 2 null
1003 3 7

select * from table的结果是newNumber和oldNumber都查询出来了
但只想要一个number：
id number
1001 1
1002 2
1003 7

number：oldnumber如果为null的话就取oldNumber不存在的话就取newNumber

[天-笑]

select id,isnull(oldnumber,newnumber) as number from table

[SQL77]

[Quote=引用 1 楼 的回复:]
SQL code



select id,isnull(oldnumber,newnumber) as number from table
[/Quote]
+1

[amazeyeli]

SELECT id,
  CASE 
    WHEN oldNumber IS NULL THEN newNumber
    ELSE oldNumber
  END AS Number
FROM Table

[amazeyeli]

又学到一个:

SELECT id,COALESCE(oldNumber,newNumber) AS Number FROM Table