DEVFYI - Developer Resource - FYI

When do you use WHERE clause and when do you use HAVING clause?

ORACLE Interview Questions and Answers (Part 4)


(Continued from previous question...)

543. When do you use WHERE clause and when do you use HAVING clause?

HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause. The WHERE clause is used when you want to specify a condition for columns, single row functions except group functions and it is written before GROUP BY clause if it is used.

(Continued on next question...)

Other Interview Questions