SQL theoretical concepts: WHERE vs HAVING, Rank vs Dense Rank, Joins, CTEs
Filed under Uber
The question
Explain the differences between WHERE and HAVING, RANK vs DENSE_RANK, INNER vs LEFT JOIN, and describe scenarios when Common Table Expressions (CTEs) should be used.
No write-up yet. Related questions below have one.
Related Uber questions
Collected from public candidate posts and coding forums. Updated Nov 2026.