"Day 2: Learning SQL Window Functions & Ranking"

Hi everyone 👋

Today I learned some very important SQL concepts:

Window Functions → OVER(), PARTITION BY

Value Functions → FIRST_VALUE(), LAST_VALUE()

Ranking Functions → ROW_NUMBER(), RANK(), DENSE_RANK()

Conditional Logic → CASE

✅ This helped me understand how we can analyze data row by row and also apply ranking inside groups.
🚀 Posting my daily SQL learnings here. Tomorrow I’ll continue with more advanced SQL topics.