Interview Q&A / SQL & DBMS
SQL & DBMS interview questions
Joins, keys, normalisation, indexes and transactions for placement and backend interviews.
Prefer rapid revision? Practise SQL & DBMS short interview answers →
- What is the difference between WHERE and HAVING?
WHERE filters individual rows before they are grouped, so it cannot use aggregate functions like SUM or COUNT. HAVING filters groups after GROUP BY has combined the rows, so it is where conditions on aggregates go.
BeginnerIn-depth3 min read - How does GROUP BY work with more than one column?
GROUP BY with several columns makes one group for each unique combination of those column values, and aggregates are computed inside each combination.
BeginnerQuick answer1 min read - How is a window function different from GROUP BY?
GROUP BY collapses rows into one row per group. A window function computes an aggregate or rank over a set of related rows but keeps every original row in the output.
BeginnerQuick answer1 min read - Why does SELECT with GROUP BY fail when you pick a column that is not grouped?
After grouping, each group becomes one output row, so a column that is neither in GROUP BY nor inside an aggregate has many possible values and the database cannot pick one. Group by it or aggregate it.
BeginnerQuick answer1 min read - Write a query to list departments that have more than 5 employees.
Group by department and filter groups with HAVING COUNT(*) > 5. WHERE cannot be used because the count exists only after grouping.
BeginnerQuick answerCoding1 min read