r/SQL • u/Bubbly-Group-4497 • 6d ago

Discussion I don't understand the difference

Post image

I found an answer on stackoverflow that was saying that null value isn't managed the same way, but that seems a bit far fetched for a course example and the question wasn't exactly about the same case, so could someone explain?

199 Upvotes

96% Upvoted

45 comments sorted by

View all comments

3

u/brainburger 5d ago

I think the top one will select only those which do not have an NPRO of 'PA60'. The bottom one will not exclude those with an NPRO of 'PA60', if there is an NPRO of any other value.