Skip to content

Instantly share code, notes, and snippets.

@briu

briu/nulls.sql

Last active September 18, 2019 06:57
Show Gist options
  • Save briu/a1f5feefae11b5d4ac71b0341cb05079 to your computer and use it in GitHub Desktop.
Save briu/a1f5feefae11b5d4ac71b0341cb05079 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
nulls.sql
CREATE TABLE tmp4(tmp_id integer);
insert into tmp4 (tmp_id) values (1), (2), (null);
select count(tmp_id <> 1) from tmp4;
select count(*) from tmp4 where tmp_id <> 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment