Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ FAQs/ How do I determine whether a column is null?
Updated on 2025-08-19 GMT+08:00
How do I determine whether a column is null?
Answer: Use IS NUL and IS NOT NULL to determine whether a column is null.
Example:
gaussdb=# SELECT * FROM tab WHERE col1 IS NULL; Parent topic: FAQs
What is your overall rating for this page?
0
1
2
3
4
5
6
7
8
9
10
Very dissatisfiedVery satisfied
Thank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.