SQL语句组成视图 ( 积分: 50 )

S

sdtrm

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-22

• #1

有一表如下:
Select a,b,c,d,e,f,g From Table
现在有一计算字段 X,
要求如下:
if a=1 then X = 10
else
if b<>null then X=20
else
if c=1 then X=30
else
X=40
最后要求视图的返回集为
Select X,d,e,f,g From View
谢谢...

 

D

djrj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-22

• #2

select X=(case when a=1 then 10
when not (b is null) then 20
when c=1 then 30
else 40 end),
d,e,f,g
from View

 

S

sdtrm

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-22

• #3

谢谢...