Login / Sign Up

SQL Questions

View All Languages
Filters:
Tricky

Moving Average

Open to read the full question, answer, code and follow-ups.

SQL91
#practice#learning
Read
Medium

Top N per Department

Open to read the full question, answer, code and follow-ups.

SQL92
#practice#learning#window-functions
Read
Tricky

Second Highest Salary

Open to read the full question, answer, code and follow-ups.

SQL93
#practice#learning
Read
Tricky

Nth Highest Salary

Open to read the full question, answer, code and follow-ups.

SQL94
#practice#learning
Read
Tricky

Latest Record Per Group

Open to read the full question, answer, code and follow-ups.

SQL95
#practice#learning
Read
Tricky

Duplicate Detection

Open to read the full question, answer, code and follow-ups.

SQL96
#practice#learning
Read
Tricky

Percentile

Open to read the full question, answer, code and follow-ups.

SQL97
#practice#learning
Read
Medium

Rolling Average

Open to read the full question, answer, code and follow-ups.

SQL98
#practice#learning
Read
Medium

Cumulative Sum

Open to read the full question, answer, code and follow-ups.

SQL99
#practice#learning
Read
Tricky

Window Frame

Open to read the full question, answer, code and follow-ups.

SQL100
#practice#learning#window-functions
Read
Tricky

Scalar Subquery

Open to read the full question, answer, code and follow-ups.

SQL101
#practice#learning
Read
Medium

Correlated Subquery

Open to read the full question, answer, code and follow-ups.

SQL102
#practice#learning
Read
Medium

Nested Subquery

Open to read the full question, answer, code and follow-ups.

SQL103
#practice#learning
Read
Tricky

EXISTS vs IN

Open to read the full question, answer, code and follow-ups.

SQL104
#practice#learning
Read
Tricky

ANY

Open to read the full question, answer, code and follow-ups.

SQL105
#practice#learning
Read
Tricky

ALL

Open to read the full question, answer, code and follow-ups.

SQL106
#practice#learning
Read
Medium

CTE

Open to read the full question, answer, code and follow-ups.

SQL107
#practice#learning
Read
Hard

Recursive CTE

Open to read the full question, answer, code and follow-ups.

SQL108
#practice#learning
Read
Hard

Hierarchy Queries

Open to read the full question, answer, code and follow-ups.

SQL109
#practice#learning
Read
Tricky

CTE vs Subquery

Open to read the full question, answer, code and follow-ups.

SQL110
#sql#practice#learning
Read
Tricky

Recursive Employee Tree

Open to read the full question, answer, code and follow-ups.

SQL111
#practice#learning
Read
Tricky

Latest Order Per Customer

Open to read the full question, answer, code and follow-ups.

SQL112
#practice#learning
Read
Medium

Top Customer Query

Open to read the full question, answer, code and follow-ups.

SQL113
#practice#learning
Read
Medium

Recursive Categories

Open to read the full question, answer, code and follow-ups.

SQL114
#practice#learning
Read
Hard

Bill of Materials

Open to read the full question, answer, code and follow-ups.

SQL115
#practice#learning
Read
Medium

Clustered Index

Open to read the full question, answer, code and follow-ups.

SQL116
#practice#learning
Read
Medium

Non-Clustered Index

Open to read the full question, answer, code and follow-ups.

SQL117
#practice#performance#learning
Read
Hard

Composite Index

Open to read the full question, answer, code and follow-ups.

SQL118
#practice#performance#learning
Read
Hard

Covering Index

Open to read the full question, answer, code and follow-ups.

SQL119
#practice#learning
Read
Tricky

Unique Index

Open to read the full question, answer, code and follow-ups.

SQL120
#practice#learning
Read