0

What is the difference between where and having clause??

26th Nov 2016, 11:25 AM
Amol Bhosale
Amol Bhosale - avatar
3 Answers
+ 2
In SQL: 1. the WHERE clause is used only to place condition(s) on selected column(s), whereas 2. HAVING clause is used to place condition(s) on groups created using GROUP BY clause. For such groups, we cannot use the WHERE clause. Hope this helps. :)
26th Nov 2016, 11:52 AM
PythonProMaybe
+ 2
You are most welcome! :)
26th Nov 2016, 11:58 AM
PythonProMaybe
0
thanku 😃
26th Nov 2016, 11:57 AM
Amol Bhosale
Amol Bhosale - avatar