Member-only story
SQL Features (That Will Set You Apart, For Sure!)
So Adi is back again, after overdosing on caffeine and using my personal slave custom GPTs. In this article, I’ll discuss some rarely talked-about SQL features that can make your SQL skills stronger and help you stand out from the crowd (a.k.a. the “wannabes” near you).
If you’re serious about becoming an SQL pro, make sure to check out my Data Analytics Mastery Course — where I teach advanced SQL, real-world analytics projects, and SQL interview tricks. Oh, and for instant learning, grab my SQL Resource Pack that includes query templates, datasets, cheat sheets, and SQL case studies. Links at the end. 📌
1. EXCEPT in SELECT Clause
Picture this — you’re working with a monster table with 500 columns, and out of those, you need to exclude just 10 system-generated columns.
Normally, you’d have to manually write out every column except those 10, which is a huge pain (trust me, I’ve been there).
While using SELECT * is generally discouraged (please, for the love of clean SQL, don’t use it), it can be useful in ad-hoc analysis or MVPs where explicitly specifying columns is a nightmare.
