Dataford
Top 50
Topic roadmap
Updated weekly · Last refresh Sep 13

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
84companies 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. 24 questions · ~542 min
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
Second Highest Value in SQLEasy
Practice
Recently asked

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

aggregationsql queriesIQVIASmartsheetEnova International
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 FinancialAApteanCollabera
SQL: Highest Marks Per DepartmentEasy
Practice
Recently asked

Use RANK and a department join to find every student tied for the highest marks in each department.

aggregationqueriessqlPractoMphasisAAppian
SQL for Second Largest ValueMedium
Practice

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

aggregationsqlTeradataDDronaHQVViridien
Retention Rate SQL With JoinsMedium
Practice

Calculate consecutive-month customer retention rates using joins, aggregation, and date-based CTEs.

aggregationsql queryTiger AnalyticsCCorGTADDS Group
More SQL & Data Manipulation questions with a free account
2
Coding26 questions · ~588 min
Letter Frequency CountingEasy
Practice
Recently asked

Count case-insensitive letters with a frequency map and return them in alphabetical order.

aggregationArraysstring manipulationInc.Inc. InVisa
Most Frequent CharacterMedium
Practice

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

aggregationfrequency countArraysCapgemini Government SolutionsIBS SoftwareCapgemini FSSBU
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.