question query to find the null table detail in Phoenix in Archives of Support Questions (Read Only)

query to find the null table detail in Phoenix

ashneesharma88 — Thu, 26 May 2016 15:25:21 GMT

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

asinghal — Thu, 26 May 2016 15:40:12 GMT

In Phoenix, an empty string is same as null.

You can run below query:-

select * from table where col_name is null.

ashneesharma88 — Thu, 26 May 2016 15:42:19 GMT

Thanks it works...!!!!!