โ† Uber questions

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.