帮写一条简单的select语句

[lula]

查询表t_number当字段fno为空时的所有行

[filebat]

select * from t_number where fno is null

[点点星灯]

select * from t_number where fno=null or fno=''

[filebat]

呵呵, 我快一点.

顺便说一下, fno=null是无效的(因为不管fno为什么值,结果都是false)

[hardlion]

select * from t_number where fno is null or fno = ''