Top 50
Topic roadmap
Updated weekly · Last refresh Sep 13

Top 50 null values Interview Questions

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

50questions
~10htotal time
66companies 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. 45 questions · ~565 min
Rolling Average Over Last 30 DaysMedium
Practice

Calculate each customer's 30-day rolling engagement average using a PostgreSQL window function.

Date FunctionsData ManipulationAggregationsTTecholutionSSignifyEEleos Health
Second Highest Value SQLEasy
Practice
Recently asked

Use a scalar subquery and MAX to find the second distinct annual salary.

sql queryRankingdatabase queryingLLuxoft SingaporePCS Global TechAmazon Web Services
SQL: Second and Nth Highest SalaryMedium
Practice

Return employees tied at the second and fourth highest non-null salary levels using salary ranking.

sqldatabase queryingAggregationsNCR AtleosHashedIn by Deloitte
Extract Player DemographicsEasy
Practice

Extract each Zynga player's demographic attributes from the users table and return them in player ID order.

JoinsData ManipulationData WranglingZynga
SQL Average Consumption By RegionEasy
Practice

Calculate average energy consumption for each known TotalEnergies region.

JoinsGroup ByAggregationsTotalEnergies
Top 10 Most Watched QueryMedium
Practice

Use joins and aggregation to return the 10 anime series with the highest total watch count.

JoinsRankingAggregationsCrunchyroll
Find the Second Highest SalaryMedium
Practice

Find the second highest distinct salary from an employee table, handling duplicate and NULL salary values.

database queryingAggregationsnull valuesAmazon Web Services
Top N SQL QueryMedium
Practice

Return the third largest distinct non-null number using PostgreSQL sorting and a subquery.

aggregationData ManipulationsqlFFinancial Software & Systems
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
2
More topics5 questions · ~63 min
More questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.