Support Questions
Find answers, ask questions, and share your expertise

query to find the null table detail in Phoenix

Solved Go to solution
Highlighted

query to find the null table detail in Phoenix

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: query to find the null table detail in Phoenix

In Phoenix, an empty string is same as null.

You can run below query:-

select * from table where col_name is null.

View solution in original post

2 REPLIES 2
Highlighted

Re: query to find the null table detail in Phoenix

In Phoenix, an empty string is same as null.

You can run below query:-

select * from table where col_name is null.

View solution in original post

Highlighted

Re: query to find the null table detail in Phoenix

Thanks it works...!!!!!