Question

SQL语句查询某个字段不为0的全部结果

查询一个表中的某个字段不为零的全部结果

Answer 1

select * from 需查询的表名 where 需查询的字段<>0 and not 需查询的字段 is null

Answer 2

select * from tablename where 字段<>0

Answer 3

select * from table where 字段<> 0

Answer 4

select * from table where isnull(field,0)<>0

Answer 5

select * from table where 字段<> 0