having clause in sql | Oracle Database

Oracle Database Full Course 👇👇
• Oracle Database | SQL
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-zx3ho]

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".

[@shahbazkhan-pv8rg]

you are great teacher thanks bro

[@shaikadil5041]

DBMS mcqs kar na bhaiya

[@abhi7155]

this vedio is helpfull✨

[@neeturai1448]

Wow sir I like your video a lot 🥰😍

[@LearnCodingOfficial]

Thank you, thank you so much

[@pritichavan1160]

Thanks sir 🙏

[@apnateacher1876]

Ok bhai makes some important mcqs of computers

[@villagelifemubashirsattar5032]

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

[@niteshdeshwal5899]

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.

[@faiyazahmad21]

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

[@khagendramohanta2127]

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

[@rupalipatil8335]

Awesom sir 👍👍

[@asharaju4169]

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

[@abdulrehman111]

Make a complete playlist on DSA with java

[@khagendramohanta2127]

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

[@LearnCodingOfficial]

Thanks brother 🙏

[@navyangaming8583]

thank you sir

[@aartikumarikushwaha1521]

Great

[@bhartirajput4868]

kindly make more such videos on sql interview questions.

[@vasunarayanajrcollege3008]

thanks

[@asifraza7325]

11:30 mein background mein paanipuri wala tha 😋😋

[@onlymahakalbhakt3964]

Best app konsa hai coding ke liye

[@sangamsharma7832]

😊

[@RavinderSingh-zx3ho]

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.

[@mohdayaz4417]

Hi sir, please suggest me which is the best RUclips channel for learning sql

[@RavinderSingh-zx3ho]

@@mohdayaz4417 Follow the SQL videos of this channel (recommended) as well as follow 1 or 2 more channels simultaneously. That way you'll know if there is gap in your learning videos, it will keep you well informed and will get your hands on more than basic SQL. There is no single channel which could provide whole picture of understanding SQL and try to follow those channels whose videos are uploaded in less than 2 years ago because of regular updates in sql.

[@mohdayaz4417]

@@RavinderSingh-zx3ho thankyou for replying that was really helpful

[@Mr_Memer01_]

Can you please explain what's the main use of having and group by?

[@smartdecoder]

💘❤💝💓

[@ziauddin8331]

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

[@subhrajyotipanda]

Sir sub query video nhi he kya mil nhi rha

[@SumanDevi-jf5dw]

Sir class 11 cs ki bhi video aayegi

[@ziauddin8331]

A message is either a queary or a response..... DNS

[@drgamer84]

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

[@LearnCodingOfficial]

Thank you so much debaraj, thank you

[@faiyazahmad21]

@@LearnCodingOfficial sir java ka koi book recommend kijiye with author name

[@drgamer84]

@@LearnCodingOfficial thx sir

[@LearnCodingOfficial]

Aap 3-4 books download kro aur padho jo best lge usko padho aur baaki ko delete kr do

[@faiyazahmad21]

@@LearnCodingOfficial sir aapne kis book se padha h

[@RavinderSingh-zx3ho]

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.

[@mohdayaz4417]

Pls help me out with learning sql...

[@mohdayaz4417]

Pls give me ur what's app number sir I want learn sql

[@PawanKumar-ic3td]

Excellent work sir nice

[@ziauddin8331]

sir mere ye questions per lecture banaye...

[@sachinjagtap7760]

Hiii sir plz provide a java full pdf notes

[@50_kunalkanherkarpatil74]

Upload all core Java

[@LearnCodingOfficial]

Core java full course 👇
ruclips.net/video/VZg5r9i90z0/видео.html

[@akshayshrivastava592]

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

[@Anumeha]

Do we use "where" with aggerate Function

[@aishakhanzada3165]

No

[@harshitkhemka5571]

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

[@LearnCodingOfficial]

Actually we are two guy, Ankush & Akhilesh.
Voice provided by Akhilesh and Hand written notes prepared by Ankush

[@harshitkhemka5571]

@@LearnCodingOfficial Thanks ☺
Amazing..👍🏻👍🏻

[@battukgamingyt3123]

Payton par video banao sir ji or full video or note ke and pdf ke sath banao

[@LearnCodingOfficial]

Work is under progress

[@AissmsDesai]

Sir what is difference in having clause and where clause??

[@sohailstark3229]

Where clause is used to apply condition on records. Having clause is used to apply conditions on groups

[@rajkarhalder7823]

Sir dpi ka ha?

[@ziauddin8331]

the request and release of the resource are.......

[@ziauddin8331]

sir protocol per ap ka vedio nehe mila?

[@LearnCodingOfficial]

Networking name se playlist hai usi me hai

[@divyesp7802]

Sir python k videos kab aayen ge ???

[@LearnCodingOfficial]

BHUT jldi

[@divyesp7802]

@@LearnCodingOfficial kon si date se start karen ge ??

[@rohanrouth6592]

Clause

[@shaikadil5041]

Plzzz🙏🙏🙏🙏🙏🙏

[@ziauddin8331]

one's complement of string..... 01010100

[@shivamdevrani0640]

Yrr meri smj m kuch nhi aa rha h abhi first time h koi h sikhane wala to msg kr do plzz

[@LearnCodingOfficial]

Shivam....plz aap hame instagram pe msg kre. We'll help u🙂

[@learningcoding5158]

Most important computer mcqs

[@akshayshrivastava592]

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