Sector file // sql
SQLDECODED.
Joins, indexes & queries
82 Questions56.3k Views3.4k Upvotes
15 easy51 med16 hard
Easy
3 questionsWhat is the logical order of execution of a SQL query?
DSA · 1.1k views · order-of-execution
Views:1.1kLikes:70
What is the difference between WHERE and HAVING?
DSA · 1.0k views · where, having
Views:1.0kLikes:45
How do you find duplicate rows in a table?
DSA · 694 views · duplicates, group-by
Views:694Likes:6
Medium
4 questionsWhat is a subquery and what is a correlated subquery?
DSA · 1.2k views · subquery
Views:1.2kLikes:4
How does GROUP BY work with aggregate functions?
DSA · 1.1k views · group-by, aggregate
Views:1.1kLikes:27
How does SQL handle NULL values?
DSA · 940 views · null
Views:940Likes:73
What are window functions?
DSA · 477 views · window-functions
Views:477Likes:78
Seen a SQL question that is not here? Add it and help the next candidate.
Share a question