Top 50 null handling Interview Questions
The most frequently asked null handling questions across all roles and companies, ranked by real interview frequency. Updated daily.
Replace missing sales fields with defined defaults and return a consistently ordered dataset.
University of Minnesota
The Home Depot
NationwideFilter invalid game events and normalize event names using PostgreSQL string and null handling.
Quantium
Scopely
CarvanaCreate an auditable application dataset by applying explicit PostgreSQL rules for missing candidate, status, salary, and date values.
Aircall
athenahealth
HaysReturn the second-highest distinct non-null salary from a single employee table.
PayU
Itc InfotechCalculate three-day rolling user activity averages and classify behavior trends with SQL window functions.
Demonstrate how left and inner joins differ when matching Firstnet Global customers to orders.
Cubic
FIRSTNET GLOBALBBanque Nationale du Canada/National Bank of CanadaDemonstrate INNER, LEFT, RIGHT, and FULL OUTER JOIN behavior using matched and unmatched records.
SAICKKreditBeeZZeroCodeHRWrite a PostgreSQL join that preserves all orders and clearly classifies NULL and unmatched customer keys.
Pattern
Swiggy
QuantiphiSign up to see every question
Create a free account to unlock this list and practice real interview questions.