InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
When Do You Use Where Clause And When Do You Use Having Clause? |
|
Answer» 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. 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. |
|