Find duplicate emails in SQL with GROUP BY and HAVING, list the duplicate rows, ignore case and spaces, delete duplicates safely, and prevent them with a unique index.
Interview Insights and Technical Explorations
Find duplicate emails in SQL with GROUP BY and HAVING, list the duplicate rows, ignore case and spaces, delete duplicates safely, and prevent them with a unique index.
Atomicity, consistency, isolation and durability explained with a bank transfer, plus isolation levels and the read anomalies they prevent.
Database normalisation explained with one table taken from unnormalised to 1NF, 2NF and 3NF, plus BCNF and when to denormalise.
INNER, LEFT, RIGHT and FULL OUTER JOIN explained with two small tables and their exact output, plus how to find rows with no match.
Four ways to find the second highest salary in SQL (MAX subquery, DENSE_RANK, LIMIT/OFFSET and TOP), how to handle ties and missing rows, and how to get the Nth highest.