having clause in sql | Oracle Database

Oracle Database Full Course 👇👇

Don't forget to tag our Channel...!
#oracledatabase
#oracle
#sql
#havingclause
#sqlhavingclause
#groupbyclause
#sqlgroupbyclause
#sqlselectcommand
#oraclesql
#oracle11g
#ask4help
#LearnCoding

|| Content ||
1. voice 🔊 :- akhilesh
2. writer ✍ :- ankush

Thank You
👌👌👌

[RavinderSingh-zxho]

Last query is only reflecting the result with "WHERE" clause, where ESAL>20000. This is why the output is count of sales from (Row 7 & Row 10), count of HR (Row 5 and Row 11) and count of Product (Row 8).

Output:
HR 2 (Row 5 and Row 11)
Product 1 (Row 8)
Sale 2 (Row 7 & Row 10)

This query is not even considering the having clause. This tutorial is not serving its purpose "having clause in sql".

[asharaju]

but having clause perform its operation only after groups are formed right then how you use it before GROUP answer

[khagendramohanta]

Sir apki videos bahut acha hai ..mera frnds Sab apko hi follow kar rahe hain

[villagelifemubashirsattar]

Good Teacher ho ap very nice Beautiful AP ka bohat shakira ap mari zanding ma hay.Thanks Sir😍💐👍Thanks 22Jan I am Pakistani

[KavitaSharma-uhb]

Esme agr limit use krna h vo kause use hoga ? Plz btado sir

[niteshdeshwal]

can we use having clause before group by statement??? My system is showing error in that code. If i use having statement after group by than the code is giving me correct result.

[apnateacher]

Ok bhai makes some important mcqs of computers

[RavinderSingh-zxho]

Correct query should be:

SELECT DNAME, COUNT(DNAME), SUM(ESAL)
FROM EMP
WHERE ESAL > 20000
GROUP BY DNAME
HAVING SUM(ESAL)>25000;

OUTPUT:
DNAME COUNT(DNAME) SUM(ESAL)
HR 2 86000
SALE 2 62000

Only HR and SALE are the department with:
1. where ESAL is >20000
2. having sum of salary > 25000.

Hope it helps for the people who'll visit this video in future.

[subhrajyotipanda]

Sir sub query video nhi he kya mil nhi rha

[abdulrehman]

Make a complete playlist on DSA with java

[faiyazahmad]

Aapka video lazawab h sir adv. Java or android development par bhi video bna dijiye please🙏🙏🙏🙏

[bhartirajput]

kindly make more such videos on sql interview questions.

[asifraza]

11:30 mein background mein paanipuri wala tha 😋😋

[akshayshrivastava]

Last vala query samjh nhi aya usme sum kaise aya ye btaiye

[khagendramohanta]

U are great sir ...plz upload full java framework videos .thank you sir

[RavinderSingh-zxho]

2nd condition can be achieved by using "WHERE" clause as mentioned below:

SELECT DNAME, ESAL FROM EMP
WHERE ESAL >= 30000
group by NAME, ESAL;


Having clause was introduced coz where clause cannot be used with aggregate functions like having count(*), having(sum), having(max), having(Avg), etc. We cannot use where count(*), where(sum), where(max), etc. in SQL.

This is the main reason why we can't use 'where' in some places and 'having' clause was introduced.

[harshitkhemka]

Thanks bhya... Par mere mann mein ek sawal hai apka naam kya hai??

[drgamer]

you are a great youtuber bro me hamesha apke sath rahunga
me har din mere dost ko keheta hu ki apki channel ko subscribe kare

[ziauddin]

what is ASK change?
FDM, wDM and TDm what?

[Anumeha]

Do we use "where" with aggerate Function