79537259

Date: 2025-03-26 20:56:25
Score: 0.5
Natty:
Report link

For larger databases, where (not) exists is usually faster, especially on indexed columns such as id.

SELECT id, name
FROM t1
WHERE NOT EXISTS (
    SELECT id
    FROM t2
    WHERE t1.id= t2.id
);
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: summer7