Dataford
Dataford
Top 50
Topic roadmap
Updated weekly · Last refresh Nov 1

Top 50 aggregation Interview Questions

The most frequently asked aggregation questions across all roles and companies, ranked by real interview frequency. Updated daily.

50questions
~19htotal time
110companies covered
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 18 questions · ~418 min
SQL Query for Third LargestMedium
Practice
Recently asked

Use a CTE, join, and RANK window function to find employees earning the third-highest distinct salary.

aggregationsqlSun Life FinancialIImpetus TechnologiesGGo Digital Technology Consulting
Second Highest Value in SQLEasy
Practice

Find the second highest distinct CRP value from completed trials using a join and DENSE_RANK window function.

aggregationsql queriesIQVIASmartsheetEnova International
SQL Query for Max Per DepartmentMedium
Practice

Retrieve each department's maximum employee salary using a join and aggregation.

aggregationJoinsGroup ByIIndium SoftwareAAmdocsChargebee
Rolling Window Customer TransactionsMedium
Practice
Recently asked

Aggregate posted transactions by customer and date, then calculate each customer's rolling 30-day transaction total.

aggregationDate FunctionsData ManipulationJJPMorganCapital OneXometry
SQL Second Highest AgeMedium
Practice
Recently asked

Use a CTE, DISTINCT, and a LEFT JOIN to find active Incedo employees with the second-highest age.

aggregationsqlIncedoIntegriChainPharmaACE
SQL for Second Largest ValueMedium
Practice
Recently asked

Use DENSE_RANK to find every active employee earning the second highest distinct salary.

aggregationsqlTeradataDDronaHQIIcon Resources
More SQL & Data Manipulation questions with a free account
2
Coding32 questions · ~742 min
Most Frequent CharacterMedium
Practice
Recently asked

Count characters across multiple strings and return the most frequent one with deterministic tie-breaking.

aggregationfrequency countArraysCapgemini FSSBUCapgemini Government SolutionsIBS Software
Anomaly Detection with Rolling WindowsHard
Practice
Recently asked

Detect transaction indices whose values exceed a rolling sample-standard-deviation threshold using an O(n) sliding window.

streamingaggregationfrequency countTruistRyanTTangerine
More Coding 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
The finish line: interview-readyComplete all 50 questions to finish this plan.