Lec-62: SQL Queries and Subqueries (part-4) | Having clause | Database Management System

► Structured Query Language (SQL)(Complete Playlist):

Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
►Computer Architecture (Complete Playlist):
► Theory of Computation
►Artificial Intelligence:
►Computer Networks (Complete Playlist):
►Operating System:
►Database Management System(Complete Playlist):
►Discrete Mathematics:
►Compiler Design:
►Number System:
►Cloud Computing & BIG Data:
►Software Engineering:
►Data Structure:
►Graph Theory:
►Programming in C:
►Digital Logic:

---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:

[DwarkaNagri]

Today 2023, July completed 4 yr of this video, but your energy, is fresh,
😅
You are a best student friendly teacher

[varunrana]

mereko IT mei dalne ke liye thank you sir xD

[hyunzae]

tbh, i had no idea regarding 'having' clause and finally came across ur video. i didn't have to watch it over and over. never seen a teaching so clear and precise. u r the best! thank you sir

[kirtimaangogna]

Thank you so much for these lectures sir, my concepts are clear, but I still watch your videos to solidify my knowledge.
Keep making these videos, and it's my request to you sir, please cover the topic of co related queries as well . :)

[swamiahirwar]

Thank you so much Varun sir
1.Gate + 2.Infosys training aapka material hi use kr rha hu
🙏🙏🙏

[shahriarrahman]

God bless you, brother. Your explanation is so clear and to the point!

[parthapal]

Some times we don't tell anyone about our basic and advance practice problems of study and we are very tensed about that, we feel very ashamed about it to tell our teacher... For this kind of situations, we are very grateful to have some teachers who feel free to give knowledge of everybody and the main thing is actually sometimes we don't know what are we want, which topic we need to study more, so this is reason that will also bother us, but here we can feel very much attention to know what we want to learn from you sir. Again huge respect ( please make more videos about all Computer Science related topics ) ...sometimes some of users like me watch your videos by download in offline so, there will be a reason that did not show you real measurement of how much students watch this video... But we watch all the videos that you uploaded.

[sunidhidwivedi]

Sir Video dobara play karne ki zaroorat hi nahi h qki aap itna accha samjhate hain🙏

[musiclovefeel]

I like the way you explain.This helped me a lot.Tx

[mahaboobbasha]

Allah apki is mehnat ko maseed tarakki ataa farmay.

Bahut Pyaare andaz se samjha rahe ho brother. Much love..

[parthapal]

Thank you sir for your lecture on this topic... It is very helpful for me because this is one of the topic where i am stuck for many times. You are really a great teacher. We are proud to have a teacher like you🇮🇳

[nazmulhossain]

One of the best teachers on YouTube. Respect from Bangladesh, sir.

[meghanakamaraju]

Life saver of every btech graduate....super bro👌👌👌👌👌👌👌👌👌👌👌👌

[tanujapawar]

In Inner Query, why don't we take select dept, count(dept) as took it in the last video.

[Chaiaurchutney]

I normally don't comment in YouTube section. But trust me this guy can really teach anyone. You are the best sir. I was having trouble with subqueries a lot. But the way you teach its amazing. God bless you sir

[TechnoDB]

Sir aapka video koi vi concept ko aasan banaata hai..
Love from Nepal Sir..

[sasikanthdashtech]

We can write the same query without using subqueries
select name, dept, count(dept) as totalcount from employee group by dept having totalcount<2;

[aliamunawar]

Great Sir agr sb teacher ap jaisa teach kren tw bht intelligent students ho jain, great sir thank you so much 💗

[AnkitJosh]

I'm a 12th standard student. Thanks, it helped me in my cbse exams

[jayeshahirrao]

U r teaching way is very simple to understand..