QUESTION 19 OF 30

Can you discuss the difference between a WHERE clause and a HAVING clause?

This technical question asks you to compare two techniques utilized when developing a new software application. This is a typical example of a technical question. When responding to this type of question, first define each term and then compare them. In some cases, you may want to state the advantages one offers over the other, or provide an example of how they are used to strengthen your answer.

"The difference between a WHERE clause and a HAVING clause is based on whether the program uses aggregated columns. A WHERE clause can only be used when there are no aggregated columns, and the program uses static non-aggregated columns. By default, the HAVING clause is used on aggregated columns."

Community answers are written by other candidates practicing this set. Reading how others frame the same question is one of the fastest ways to sharpen your own.

Anonymous Answer

Both clauses are part of an SQL SELECT command and act as filters. The WHERE clause applies filtering at the individual record level for a given condition, whereas the HAVING clause is used to filter aggregates of records by a given condition (after data has been aggregated via an aggregate clause, the set of groups is filtered by the HAVING condition). I have used the built-in ORM in Django for abstract writing SQL queries to RDBMS.

Marcie's Feedback

Nice! The interviewer will undoubtedly be very impressed by all of your technical knowledge. Adding a personal example strengthens your answer too!

Create a free account to add your own answer →

Unlock all 30 Back End Developer questions

Unlock expert responses to technical questions that separate senior from junior developers.

Get Started

Previous Question Next Question

Back End Developer Mock Interview

Can you discuss the difference between a WHERE clause and a HAVING clause?

Unlock all 30 Back End Developer questions

30 Back End Developer Interview Questions & Answers