sql 判断

[FenHui]

一个范围判断的问题

如果a和b都不为空的话 则取出c值在a于b之间的数据
这个用between a and b 可以做
但是如果b为空的话 我想要的c值大于a就可以 （相当于b为最大值）

请教下这要怎么做啊
用一条sql语句哦

[jinjazz]

between a and isnull(b,很大的数)

[dengchenlu]

用sql连接

string sql = "select * from tablename where 1 = 1"
if(a != "")
{
sql = sql + " and c > a";
}
if(b != "")
{
sql = sql + " and c <= a";
}

[孤独侠客123]

select (case when a is not null and b is not null and c>= a and c<= b then
c
when b is null and c>=a then c end ) from yourtable

[孤独侠客123]

select c
from yourtable where (a is not null and b is not null and c>= a) or (b is null and c>=a)

[liudanking]

支持ls 加条件判断就可以了

[wuyq11]

在存储过程中判断
declare @s varchar(200)
set @s='select * from table where 1=1'
if(A='' and b='')
set @s=@s+' and c between a and b'if(A='' and b='')
if(A!='' and b='')
set @s=@s+' and c > a '
exec @s