Top 50 sql queries Interview Questions
The most frequently asked sql queries questions across all roles and companies, ranked by real interview frequency. Updated daily.
Use DENSE_RANK and a CTE to find every Capgemini Engineering employee earning the second highest distinct salary.
Capgemini Engineering
Hsbc
Ion GroupFind the second highest distinct CRP value from completed trials using a join and DENSE_RANK window function.
IQVIA
Smartsheet
Enova InternationalUse DENSE_RANK and a LEFT JOIN to find active HashedIn employees earning the second-highest distinct salary.
HashedIn
Newgen Software
Sagitec SolutionsFind all employees tied for the maximum salary using a PostgreSQL CTE and explain equivalent DataFrame and RDD transformations.
Kpi Partners
Jpmorgan Chase &
ExusiaRank completed Cloud Software Group product revenue within each category using aggregation and a window function.
Cloud Software Group
Rich Products
Observe.AIFind the most active Palantir Foundry user with a date-filtered LEFT JOIN and aggregation.
Palantir technologies
PalantirFind the second-highest distinct non-NULL salary using PostgreSQL window-function logic.
Join Unity product and revenue data to calculate annual revenue and year-over-year growth with LAG.
Unity Technologies
Balyasny Asset Management
Intuitive SurgicalSign up to see every question
Create a free account to unlock this list and practice real interview questions.