Search
⌘K

Leetcode 1350. Students With Invalid Departments

Given Students and Departments tables, return the names of students whose department ID does not match any entry in Departments (i.e., students assigned to an invalid/nonexistent department). This is an anti-join/NOT EXISTS style SQL problem to filter rows with no corresponding foreign key.


Question Timeline

See when this question was last asked and where, including any notes left by other candidates.

Comments

Your account is free and you can post anonymously if you choose.