Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

query to find the null table detail in Phoenix

avatar

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

1 ACCEPTED SOLUTION

avatar

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

avatar

In Phoenix, an empty string is same as null.

You can run below query:-

select * from table where col_name is null.

avatar

Thanks it works...!!!!!