Amberjack
Reputation: 45
How to exclude 0 from my query, but include null?
I would appreciate a little help. Values in the column are 1, 0 and null. I want to write a condition where I exclude only 0, but rows with values 1 and null are included.
I did not think this would be a problem for me, but it is.
Thank you for your help!
Upvotes: 0
Views: 739
Answers (1)
Fahmi
Reputation: 37473
You can try the below -
select * from tablename
where column=1 or column is null
Upvotes: 1
Related Questions
- How to ignore rows with zero value in SQL
- SQL to exclude NULL or value 0
- How do I exclude the rows with '0' values but not the rows with NULL values in SQL?
- need to have sql query that returns all data except the one with only zeros
- query where '0'
- SQL need to get results with zero values
- How to filter the result that include null value in the query?
- ignore 0 values from a query in mysql
- SQL - how to select values which aren't 0, but may be NULL?
- Skip 0 and NULL in SQL