Top 50 queries Interview Questions
The most frequently asked queries questions across all roles and companies, ranked by real interview frequency. Updated daily.
Calculate five-day rolling service averages using daily aggregation, a calendar join, and PostgreSQL window functions.
Exl
EXL ServicevvConstructFind how many employees joined this company during this year. Asked in the Virtual Onsite stage. SQL question asked during interview rounds. Task Write ...
Amazon
Amazon Web ServicesUse RANK and a department join to find every student tied for the highest marks in each department.
Practo
MphasisAAppianUse ORDER BY and LIMIT to return Roku's two highest-paid employees.
RokuAggregate ZoomInfo Engage activities by type and date, include zero-activity combinations, and calculate day-over-day changes.
ZoomInfo
ZoomInfo TechnologiesFind duplicate active client emails using a PostgreSQL CTE, JOIN, normalization, GROUP BY, and HAVING.
Ion GroupUse a PostgreSQL LIKE filter to find Argus employees whose names begin with the letter A.
Argus Information & Advisory ServicesRetrieve the three highest non-null employee salaries using PostgreSQL ORDER BY and LIMIT.
Playstation NetworkSign up to see every question
Create a free account to unlock this list and practice real interview questions.