SyntaxFix

[postgresql] PostgreSQL 'NOT IN' and subquery

When using NOT IN, you should also consider NOT EXISTS, which handles the null cases silently. See also PostgreSQL Wiki

SELECT mac, creation_date 
FROM logs lo
WHERE logs_type_id=11
AND NOT EXISTS (
  SELECT *
  FROM consols nx
  WHERE nx.mac = lo.mac
  );

Examples related to postgresql

• Subtracting 1 day from a timestamp date • pgadmin4 : postgresql application server could not be contacted. • Psql could not connect to server: No such file or directory, 5432 error? • How to persist data in a dockerized postgres database using volumes • input file appears to be a text format dump. Please use psql • Postgres: check if array field contains value? • Add timestamp column with default NOW() for new rows only • Can't connect to Postgresql on port 5432 • How to insert current datetime in postgresql insert query • Connecting to Postgresql in a docker container from outside

Examples related to subquery

• What is the difference between LATERAL and a subquery in PostgreSQL? • Postgres Error: More than one row returned by a subquery used as an expression • How does Subquery in select statement work in oracle • Difference between Subquery and Correlated Subquery • How to do this in Laravel, subquery where in • SQL LEFT JOIN Subquery Alias • Subquery returned more than 1 value.This is not permitted when the subquery follows =,!=,<,<=,>,>= or when the subquery is used as an expression • subquery in FROM must have an alias • Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable? • How can I insert values into a table, using a subquery with more than one result?