In Presto how to query a cloumn which no value

kumar 0
Viewed 23

I have a integer column which is empty. How to query that I tried

select * from table where target_status_code = null

but it did not return anything

enter image description here

amazon-athena presto
1 Answers

Probably you should use is null to check the integer column which is empty:

select * from table where target_status_code is null
ramsay0
Related