RootCauseunvalidated
where x.col2 not in (select col2 from table2) — Now I want to remove the entries from above result which are in table2. Tension: are there any cases that I could be missing? Outcome: Depending on which DBMS you're actually using, you could use window functions and exist expressions.
b1c0aa4f-fa48-4dbc-8fcb-d84c06851911
where x.col2 not in (select col2 from table2) — Now I want to remove the entries from above result which are in table2. Tension: are there any cases that I could be missing? Outcome: Depending on which DBMS you're actually using, you could use window functions and exist expressions.