Forum Discussion
undefined
I have a three column i want a result like it select" T " from col1- and that should not contain 0 and null from col2 and col3 col1 col2 col3 A 1 null A 2 ...
Hi Anonymous ,
what's your meaning of "not contain 0 and null from col2 and col3",from your description, I know you want to filter col1，but I don't understand "not contain o and null", because unless you delete col2 and col3, if you filter on this table, it will show the whole row.
So can you give me your expected result? so that i can know what you want.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.