query to find the null table detail in Phoenix

[#1]

can any one help me with query to find the details with null or empty column value from pheniox .

[#2 · Accepted solution]

In Phoenix, an empty string is same as null.

You can run below query:-

select * from table where col_name is null.

[#3]

Thanks it works...!!!!!