WHERE vs HAVING Clause | Oracle SQL Tutorial Videos | Mr.Vijay Kumar

thanks

Just perfect. on spot explanation

Important explaination in simple language and very easy to understand
Thanku sir

Super sir

Well explanation Sir. really useful to me sir . thankyou sir

Great Explanation..Sir can u please do a vedio on --Primary Key and foreign Key and Integrity constraint

Superrbbbb

👍👍👍👍

then what is the difference between partition by and group by ?

update difference between not in & not exists and also in and exists

abe chutiye kitna "group by group by" bolta hai

Sir please explain oracle architecture

Thankyou sir

Very good explanation

We can use Having by Clause before Group by Clause from Oracle 11g Onwards,
Example:

SELECT DEPTNO,SUM(SAL) SUM_SAL
FROM EMP
WHERE DEPTNO IN(10,20)
HAVING SUM(SAL) > 5000
GROUP BY DEPTNO
ORDER BY 1 DESC;