Skip to content

Problems Questions Drills Roles Skills Interview Contest Leaderboard

Problems Questions Drills Roles Skills Interview Contest Leaderboard

Home
Data Engineer
Questions
Window Functions

Data Engineer

Window Functions questions

6 questions on Window Functions for data engineers, easiest first.

Medium 3

Keeping the latest row per keymedium
RANK and DENSE_RANK with tiesmedium
Day-over-day change with LAGmedium

Hard 3

Running total with tied dateshard
LAST_VALUE returns the current rowhard
Longest login streakhard

More Data Engineer skills

SQL 24 Data Modeling 13 Performance 12 Spark 10 Kafka 9 Orchestration 6 Joins 6 Airflow 6 Dbt 6 File Formats 5 Streaming 5 Incremental Loads 5 Null Handling 4 Aggregation 4 Scd 4 Data Quality 4 Idempotency 4 Lakehouse 4

Window Functions across all roles →

🏆 Window Functions leaderboard →

RED SAG Skills

Free practice for every job role: coding problems, role challenges and mock interviews. Built and managed by RED SAG Fintech Solutions.

Software Engineering

Frontend Developer interview questions
Backend Developer interview questions
Full Stack Developer interview questions
Mobile App Developer interview questions
Game Developer interview questions
Blockchain Developer interview questions

Data, AI & Machine Learning

Machine Learning Engineer interview questions
AI Engineer (LLM & Generative AI) interview questions
Data Scientist interview questions
MLOps Engineer interview questions
Prompt Engineer interview questions
Data Analyst interview questions

Cloud, DevOps & Security

DevOps Engineer interview questions
Cloud Engineer interview questions
Site Reliability Engineer interview questions
Database Administrator interview questions
Cybersecurity Analyst interview questions

© 2026 RED SAG Fintech SolutionsAll roles Coding problems Leaderboard About Careers at RED SAG