79771991

Date: 2025-09-22 19:42:24
Score: 1
Natty:
Report link
Just dont use JOIN, use WHERE, like this:

delete from catalog.schema.table
where exists (
  select 1
  from tableWithRowsToDelete as D
  join catalog.schema.table as O
    ON O.col1 = D.col1
    AND O.col2 = D.col2
)
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: Sergio Blum