Lec-62: SQL Queries and Subqueries (part-4) | Having clause | Database Management System
HTML-код
- Опубликовано: 11 июл 2024
- 👉Subscribe to our new channel: / @varunainashots
► Structured Query Language (SQL)(Complete Playlist):
• Structured Query Langu...
Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
• Design and Analysis of...
►Computer Architecture (Complete Playlist):
• Computer Organization ...
► Theory of Computation
• TOC(Theory of Computat...
►Artificial Intelligence:
• Artificial Intelligenc...
►Computer Networks (Complete Playlist):
• Computer Networks (Com...
►Operating System:
• Operating System (Comp...
►Database Management System(Complete Playlist):
• DBMS (Database Managem...
►Discrete Mathematics:
• Discrete Mathematics
►Compiler Design:
• Compiler Design (Compl...
►Number System:
• Number system
►Cloud Computing & BIG Data:
• Cloud Computing & BIG ...
►Software Engineering:
• Software Engineering
►Data Structure:
• Data Structure
►Graph Theory:
• Graph Theory
►Programming in C:
• C Programming
►Digital Logic:
• Digital Logic (Complet...
---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
► Subscribe to us on RUclips: / gatesmashers
►Subscribe to our new channel: / @varunainashots
► Like our page on Facebook: / gatesmashers
► Follow us on Instagram: / gate.smashers
► Follow us on Instagram: / varunainashots
► Follow us on Telegram: t.me/gatesmashersofficial
► Follow us on Threads: www.threads.net/@gate.smashers
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
Email us at: gatesmashers2018@gmail.com
u r one among the best Teachers i have seen in my life
You are absolutely right because he gives explanation also like why other things will not work
ruclips.net/video/QTaiF8N6i3Y/видео.html
ruclips.net/video/QTaiF8N6i3Y/видео.html🙏🏻🙏🏻
Raja Kumar
He is a legend brother ,you wont find teachers like him in decades also
mereko IT mei dalne ke liye thank you sir xD
Today 2023 , July completed 4 yr of this video , but your energy , is fresh,
😅
You are a best student friendly teacher
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
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 . :)
Sir Video dobara play karne ki zaroorat hi nahi h qki aap itna accha samjhate hain🙏
exactly
True👍👍
ruclips.net/video/QTaiF8N6i3Y/видео.html
ruclips.net/video/QTaiF8N6i3Y/видео.html🙏🏻🙏🏻
God bless you, brother. Your explanation is so clear and to the point!
I haven't seen a teacher like you so far. After watching your videos, I can say that you are the best teacher in the world. Anyone can understand only after watching your videos once only. No need to watch it again and again. Great way of explaining things in an easy way. I really appreciate the hard work you are putting to educate the people around the world. Can you provide me SQL training? I live in Delhi. Thank you :)
I feel the same. ✌
ruclips.net/video/QTaiF8N6i3Y/видео.html
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🇮🇳
Sir your channel is too under rated
Your channel should have more than 2M subscriber at least 👌👌👌
2024 Students Present here
👇
Preparing for competitive exam?
Here😊
Last night of uni exam 😅
Sir your explanation of group by is the best one I have ever come across. My concepts finally became clear. Thanks a lot!
Sir, what a teaching method, superb, you are a great teacher on youtube.
Thanks a lot Sir. Your teaching is awesome you clear our all doubts and most importantly you cover all concepts.
I watch tutorials with 1.5X playback and your videos are clear to hear and understand even at 2X speed. Good Job Smasher!
Thank you sir for making this video available for free. This helped me and my friends alot for GATE preparation and semester exams❤️❤️❤️
Thank You for all the efforts put by you. Great Explanation!!!!
Really awesome man!!!! Thank you so much for this quality content.
One of the best teachers on RUclips. Respect from Bangladesh, sir.
Super super super video ..... is tarike ki or video ka wait kr rhe h hm sab... bahut hi sandar.. teaching style h
Thank you bhai, you have resolved my doubt which is bothering me for months, very clear explanation.... All the best for your future achievements.
He is the God for CSE IT students
Sir your all videos are really awesome....it helps us alot
Life saver of every btech graduate....super bro👌👌👌👌👌👌👌👌👌👌👌👌
Your explanation is very clear....on all topics .....all videos are awesome ...I learned computer network and dbms by seeing your videos..🙏🙏
I am a beginner and I find your video really useful for understanding SQL and gaining interest in it thankyou very much
GATE 2004 question for practice
The employee information in a company is stored in the relation
Employee (name, sex, salary, deptName)
Consider the following SQL query
select deptName
from Employee
where sex = 'M'
group by deptName
having avg (salary) > (select avg (salary) from Employee)
It returns the names of the department in which
A
the average salary is more than the average salary in the company
B
the average salary of male employees is more than the average salary of all male employees in the company
C
the average salary of male employees is more than the average salary of employees in the same department
D
the average salary of male employees is more than the average salary in the company
Option C??
Sir aap south movie k actor lg rhe ho 😛
C
sir c ans...plz batye is it right
"D" IS THE RIGHT ANSWER
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.
This is my fav channel to learn ❤️
Great define..Sir ji all the subqueries..
Best teacher ever. Thanks a lot, Sir. 🙏🙏🙏
Sir aapka video koi vi concept ko aasan banaata hai..
Love from Nepal Sir..
Great Sir agr sb teacher ap jaisa teach kren tw bht intelligent students ho jain , great sir thank you so much 💗
Your teaching skills are outstanding!! I wish i could learn all subjects from you.
JBH
Thanq sir. I saw many videos on this topic I confused more one after another video.. U made it very very clear even I know very small hindi.. Ur teaching is best option for beginners especially... Keep going sir...
great explanation of nested queries !! :D
I normally don't comment in RUclips 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
Thank you for making the concept very clear. Thank you so much
Thank you so much Varun sir
1.Gate + 2.Infosys training aapka material hi use kr rha hu
🙏🙏🙏
Wonderful. Even non-technical background can understand.
you are life saver.
You r the best teacher ever learnt @gatesmasher💯💯🔥❣️
bhot zabardast smjhate ho yar ap appreciates your hard work brother
sir thanks for this playlist..it is a huge help for a guy from non cs,it stream
Understood the query very easily 💯.
Excellent explanation sir I just loved watching your video 👌
You r great sir .. pls dont say thanks at the end as we must be thankful to u for these wonderful videos to improve our databases skills... A big thanks to u🙏🙏
All the video lectures is clearly understand and clear all my doubt.
Thank you sir, great queries so far
Thank you sir....solved all my DBMS doubts...
Sir your teaching is fabulous!!!!
fantastic sir..ur explanation was rad in the video..
excellent ..very helpful work...
Thank you sir for the valuable information.
Relally by heart you explaineation superb really
Really sir you are the best and your teaching style is very osm...
Ur explanation are soo good and understandable
Thank you sir . It was very helpful.
Brother, your lecturers are awesome. Hang in there.
I like the way you explain.This helped me a lot.Tx
ThaNkyou So Much Sir.....Please Keep Making These Videos
Thank you so much Sir..
Nice presentation.
Thank you sir for your class.it was very understandable your class was very nice ❤️
You made easy to learn complex query sir ji... :)
These are Gold
You are Very Great Professor...😍
Very nicely explained sir. So thanks sir
thanks a lot for everything you taught ,I am grateful
I have same doubt .
I was thinking the query should be
Select dept from emp where count(dept)
Wow sir you make it so easy for me to understand this
Very nice...easiest way to understand each topic..gbu sir
Wow... The way you teach is lit 🔥man!!!
Fantastic. Brilliant
thanks for posting this informative video👍👍👍
Super Cool... Great Teacher😍❤❤
Thank You Man, Helped a lot 🙏🏼
Bohot dhanyabad sir ji❤️🙏
Being a class12 cs stud really helped me!
N thank you so much sir for easy explaination 😍🙌🏻
Lecture is well explained i must say you are better than my University Professor.
very easy to understand your lecture.Thanks a lot
Brother You are doing great job, keep it up...... Lots of love From Pakistan
I like DBMS because of you, well explained sir all
You are different excellent job
Great explanation sir jii 🔥🔥🔥
you are simply fabulous
Sir,I like your teaching style ❤
Gurujee shandhar jabardast zindabad
thank you so much sir.
Your teaching method is too good...
Thanks very well explained concepts are very clear
Awesome sir thank you🙏
U r teaching way is very simple to understand..
Hello sir I am fresher... looking jobs on SQL so Which topics prepare for interview.
U r life savior!
thank you sir,its clear
Ur * the best * teacher sir
Your videos are awesome sir.
Allah apki is mehnat ko maseed tarakki ataa farmay.
Bahut Pyaare andaz se samjha rahe ho brother. Much love..
Shukriya 🙏
Very nice collections of sub queries videos
bahut ache ho aap bhaiya,bahut ache se smjhaate ho
You are brilliant Sir