SQL ACADEMY • MODULE 23SQL Window Functions
Learn how window functions analyze rows while preserving the original result set.
Advanced📚 10 Lessons⭐ 0 / 15850 XP⏳ In Progress
0 / 10 Lessons Completed (0%) LESSON 141🔓 ROW_NUMBER
⏱ 3 Mins • ⭐ 1540 XP • Advanced
LESSON 142🔒 ROW_NUMBER by Department
⏱ 3 Mins • ⭐ 1550 XP • Advanced
LESSON 143🔒 RANK
⏱ 3 Mins • ⭐ 1560 XP • Advanced
LESSON 144🔒 DENSE_RANK
⏱ 3 Mins • ⭐ 1570 XP • Advanced
LESSON 145🔒 LAG
⏱ 3 Mins • ⭐ 1580 XP • Advanced
LESSON 146🔒 LEAD
⏱ 3 Mins • ⭐ 1590 XP • Advanced
LESSON 147🔒 Running Total
⏱ 3 Mins • ⭐ 1600 XP • Advanced
LESSON 148🔒 Department Average Window
⏱ 3 Mins • ⭐ 1610 XP • Advanced
LESSON 149🔒 Salary Difference
⏱ 3 Mins • ⭐ 1620 XP • Advanced
LESSON 150🔒 Top Employee per Department
⏱ 3 Mins • ⭐ 1630 XP • Advanced