本文介绍使用SELECT语法时,not in中包含了null,结果全为真的场景。 teledb=# select * from teledb_pg where id not in (1,3); id | nickname ----+---------- 2 | TELEDB 4 | (2 rows) teledb=# select * from teledb_pg where id not in (1,3,null); id | nickname ----+---------- (0 rows)
本文介绍使用SELECT语法时,not in中包含了null,结果全为真的场景。 teledb=# select * from teledb_pg where id not in (1,3); id | nickname ----+---------- 2 | TELEDB 4 | (2 rows) teledb=# select * from teledb_pg where id not in (1,3,null); id | nickname ----+---------- (0 rows)
本文介绍使用SELECT语法时,not in中包含了null,结果全为真的场景。 teledb=# select * from teledb_pg where id not in (1,3); id | nickname ----+---------- 2 | TELEDB 4 | (2 rows) teledb=# select * from teledb_pg where id not in (1,3,null); id | nickname ----+---------- (0 rows)
本文介绍使用SELECT语法时,not in中包含了null,结果全为真的场景。 teledb=# select * from teledb_pg where id not in (1,3); id | nickname ----+---------- 2 | TELEDB 4 | (2 rows) teledb=# select * from teledb_pg where id not in (1,3,null); id | nickname ----+---------- (0 rows)
本文介绍使用SELECT语法时,not in中包含了null,结果全为真的场景。 teledb=# select * from teledb_pg where id not in (1,3); id | nickname ----+---------- 2 | TELEDB 4 | (2 rows) teledb=# select * from teledb_pg where id not in (1,3,null); id | nickname ----+---------- (0 rows)
本文介绍使用SELECT语法时,not in中包含了null,结果全为真的场景。 teledb=# select * from teledb_pg where id not in (1,3); id | nickname ----+---------- 2 | TELEDB 4 | (2 rows) teledb=# select * from teledb_pg where id not in (1,3,null); id | nickname ----+---------- (0 rows)
本文介绍如何在使用SELECT语法时添加all条件。 需要大于所有值才为真。teledb=# select * from teledb_pg where id > all (select 1 union select 3); id | nickname ----+---------- 4 | (1 row)
本文介绍如何在使用SELECT语法时添加all条件。 需要大于所有值才为真。teledb=# select * from teledb_pg where id > all (select 1 union select 3); id | nickname ----+---------- 4 | (1 row)
本文介绍如何在使用SELECT语法时添加all条件。 需要大于所有值才为真。 teledb=# select * from teledb_pg where id > all (select 1 union select 3); id | nickname ----+---------- 4 | (1 row)
本文介绍如何在使用SELECT语法时添加all条件。 需要大于所有值才为真。teledb=# select * from teledb_pg where id > all (select 1 union select 3); id | nickname ----+---------- 4 | (1 row)
本文介绍如何在使用SELECT语法时添加all条件。 需要大于所有值才为真。teledb=# select * from teledb_pg where id > all (select 1 union select 3); id | nickname ----+---------- 4 | (1 row)
本文介绍如何在使用SELECT语法时添加all条件。 需要大于所有值才为真。teledb=# select * from teledb_pg where id > all (select 1 union select 3); id | nickname ----+---------- 4 | (1 row)