Home » Interview » Technology

State one similarity and difference between WHERE Clause and HAVING Clause?

Correct Answer: Similarity: Both WHERE and HAVING Clause filters out records based on one or more conditions Difference: WHERE Clause can only be applied to a static non-aggregated column whereas HAVING is needed for aggregated columns

← Previous Question Next Question→

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion