select * from db where dm='000001' and (scbz<>1 or scbz is null) order by fsrq desc
select * from db where dm='000001' and (scbz<>1 or scbz is null) order by fsrq desc
fsrq是什么,应该改为排序列名。
select * from db where dm='000001' and (scbz<>1 or scbz is null) order by fsrq desc
select * from db where dm='000001' and isnull(scbz,0)<>1 order by fsrq desc
表db中有以下字段,guid(char(38)),dm(char(6)),zt(chat),scbz(tinyint),其中scbz有以下三种值NULl,空,1,我想选出scbz<>1并且dm='000001'的记录,sql该怎样写? select * from db(nolock) where scbz<>1 and db='000001'
fsrq是表db中的日期字段。 select * from db where dm='000001' and (scbz<>1 or scbz is null) order by fsrq desc select * from db where dm='000001' and IsNull(scbz,0)<>1 order by fsrq desc以上两种写法我都试了,最后结果只选出了scbz值为null的记录,为空的没有选出来。为何?
select * from db(nolock) where scbz<>1 and db='000001'
select * from db where dm='000001' and (scbz<>1 or scbz is null) order by fsrq desc
select * from db where dm='000001' and IsNull(scbz,0)<>1 order by fsrq desc以上两种写法我都试了,最后结果只选出了scbz值为null的记录,为空的没有选出来。为何?