请教一SQL语句 ( 积分: 50 )

J

jiangzhang3942

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-12

• #1

(case redno2 when 1,2,3,5,7,11 then 1 else 0 end)
这个sql语句怎么写呀
要是写成(case when redno1=1 or redno2=2 or redno3=3 or redno4=5 or redno1 = 7 or redno1=11 then 1 else 0 end) 太长了，像delphi中的case语句怎么写呀

 

S

starluck

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-12

• #2

select case when redno in (1,2,3,5,7,11) then 1 else 0 end

 

爱

爱上猫的鱼

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-12

• #3

select redno2=
case
when redno2=1 then dosomething
when redno2=2 then dosomething
......
else
redno2=0
end
from 表名

 

L

lngdtommy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-12

• #4

在Delphi中你把它入到STRING中,和写正常的SQL语句是一样的.

 

J

jiangzhang3942

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-10-12

• #5

接分老大