select中if

[dongbeixin]

select * from aa where a=1
这个我想修改成如果a>1,就出b>1 ,如果a<1 就出b=1
应该怎么 写语句啊，

select * from aa
where {if a>1
{b>1};
else b=1}

还是怎么写啊，
谢谢 了，在线急等

[victorcai2006]

这个我想修改成如果a> 1,就出b> 1 ,如果a <1 就出b=1
-------------------------------------------------
如果A>1,就出b>1,是否是同时要必备A和B？如果要同时必备就是下面这个写法，
如果不是，就用CASE

select * from aa where (a> 1 and b> 1)or(a <1 and b=1)

[Limpire]

select * from aa where (a>1 and b>1) or (a<1 and b=1)

[liangCK]

case

[liangCK]

if a>1
select * from aa where b>1
else
select * from aa where b=1

[tim_spac]

1):

select * from aa
where case when a>1 then b>1 else b=1 end

2):

select * from aa
where ((a>1 and b>1) or (a<=1 and b=1))

[中国风]

select
*
from
t
where
a=1 or( a>1 and b>1)or(a<1 and b=1)

[中国风]

作为条件用or
作为显示用case when ...then... end