3 ms·
You Probably Don’t Use SQL INTERSECT or EXCEPT Often Enough
- FroshKiller 11y agoFunnily enough, I cited my use of INTERSECT and EXCEPT as examples of my SQL expertise in an annual review a few years ago. It's not that they're complicated--they're piss easy--but they are little-known tools that can make you look like a wizard compared to other SQL "experts" who only use two types of JOINs.
- barking 11y agoI've used union quite a bit but never realised intersect and except existed until now