Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
find null in any column of table using PostgreSQL
CREATE TABLE T (c1 varchar(4), c2 varchar(4)) ; INSERT INTO T (c1, c2) VALUES ('1', NULL), (NULL, '2'), (NULL, NULL), ('3', '4') ; SELECT * FROM t WHERE NOT (t IS NOT NULL) ;
run
|
edit
|
history
|
help
0
postgresql
Yy
Recursive inefficiency
Current time/date, timezone
loggin_trigger-audit
1280. Students and Examinations
Query workaround in order to avoid IN Operator in WHERE Clause
Projeto
first
Joins and Case