Dataford
Top 50
Topic
~15h total · Updated weekly · Last refresh Jul 24

Top 50 Window Functions Interview Questions

The most frequently asked Window Functions questions across all roles and companies, ranked by real interview frequency. Updated weekly.

Start practicing free →
Compare Periods with LAG and LEAD
Medium

Explain how LAG and LEAD compare current rows to previous or next periods in time-series SQL analysis.

Window FunctionsLag/LeadDate Functions
Recently asked
Capgemini EngineeringBoston Consulting GroupAmazon Kuiper Commercial Services
Running Totals for Sales Reporting
Medium

Explain how to calculate cumulative totals in SQL using window functions, ordering, and optional pre-aggregation.

Window FunctionsDate FunctionsRunning Totals
Recently asked
VanguardAlabama StaffingAnalog Devices
Ranking Trial Results with Window Functions
Easy

Explain how RANK(), DENSE_RANK(), and ROW_NUMBER() differ when ordering tied clinical trial results.

Window FunctionsRankingData Wrangling
Recently asked
UKGC5iKraken
Second-Highest Segment Transaction Value
Medium

Use joins and a ranking window function to find the second-highest distinct transaction value for each customer segment.

Window FunctionsRankingGroup By
Recently asked
Sun Life FinancialMcKinsey &Teradata
Compare Weekly User Activity Trends
Medium

Aggregate user activity by week, then use LAG to compare sessions and watch time versus the prior active week.

Window FunctionsLag/LeadDate Functions
Recently asked
Publishers Clearing HouseInteractive Process TechnologyB Lab Global
Top Customers by Region Volume
Medium

Find the top 3 customers in each region by transaction volume using joins, aggregation, and window ranking.

Window FunctionsJoinsRanking
Recently asked
JPMorganChaseSilicon Valley BankArgus Information & Advisory Services
More SQL & Data Manipulation questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan

Open any question for its full solution and discussion.

Browse all questions →