Lec-61: SQL Queries and Subqueries (part-3) | Group By clause | Database Management System
HTML-код
- Опубликовано: 14 сен 2018
- 👉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
This guy is from Space... a true hero, explained it in such a simple way
I am in a company as a sql trainee and your videos are still relevant,
nothing but only love and respect for you, sir.
Just 47k subs for such a nice instructor. This guy definitely deserves lot more.
225k now......he deserves more...
@@rakibul_rkb 253k
274k subs now💕🙏🔥
here I am after a year haha :D I am working now. But thanks to this guy. Helped me clear my Engg exams
@@aniket_tripathi aye aye
massive respect to you sir... although im from non cs background... digests easily your concepts in one go... KEEP DOING THIS.. and much love and respect
Janab Kamal kr diya... Kaash k is lock down me University valy online Database ka subject perhany ki bjai apki videos recommend kr dyty... Km say km kuch seekh he jana tha na...lakin kiya kryn....perso paper hai or aaj yeh video mil gai.. chalo koi nhi semester break me krta hon yeh series complete.❤❤❤❤❤👌
I saw that each of your videos is well explained with our day to day simple examples, which makes u special other than remaining authors worldwide. I have been learning PHP and SQL since few months. But, this is the point where I found myself confident about PHP. Thanks to you bhai..
Amazing method of teaching sir....hats off sir ❤love from pakistan🇵🇰
Great video's you are gifted with your teaching skills. I would love to see more video's if possible with SQL- database testing and Teradata please.
thank you sir,this ditto same question was actually asked in my interview and i gave 90% correct answer without knowing this concept. I wish i would have seen this earlier.
great video,
only some of RUclips teachers who are professional & experts and teach great,& we can understand there teaching, you are one of them, i like your videos. keep doing
soo intelligent person.... and soo beautiful videos... i loved it .. and the way you explain...is really really interesting and easy...
congratulations sir... GOD BLESS YOU !!
Your way of teaching is amazing 😁 Even a beginner can understand clearly 👍Thank you Sir🙏
I am not a computer science student and could understand everything from your videos. Please continue making more tutorials. You are doing a great job. Best wishes :)
For why are you seen this video.
i dont know how to convey gratitude for these easy , detailed , well explained videos ."AMAZING WORK"
and now, those gate giveaway course....speachless. In the present world of low quality education, you are giving high quality education. these videos are helping lots n lots of people
The best video for solving all types of questions related to Sub queries..
thank you for your hard work sir. I always follow your videos for my doubts. Your explanation is so informative and yet simple.
You explained group by clause in a very simple way 👍👍
Wow man u are awesome,, I had visited a lot of RUclips channel over here but couldn't understand anything about this topic but your content give me some clarity and I will never forget what is group by clause,, make more tutorial like this❤ respect from West Bengal ❤
High Quality teaching skills. Respect from Pakistan 🇵🇰
Thank you
Love for you too dear ❤️@@Take-It-Easy-Man
True people of 🇵🇰 always spread love and respect with our neighbour country 🇮🇳 and expect from our neighbours to follow the same practice.
@@practicaltalks5097 love from india :).brainless people will blabber something.just ignore them.stay safe :)
@@practicaltalks5097 Great that you love and support Indians. Thank you
@@practicaltalks5097 true
Sir aap ki tu kiya he bat hy ...Best explanation with minor details..that makes u the Beast.. salute...love and respect from pakistan sir
Thank you so much sir for providing such quality content
Thank you for your efforts
I am preparing for competitive exams and your short video's helps .e to read books easily and fastly
Bhaiya Aap bohot acha samjhaate ho, aise toh mein Class 12th wala hoon lekin koi teacher GROUP BY itna accha nhi samjha paaye, you are an excellent teacher. I am grateful that I found you. Amazing Content Love your teaching style. THANK YOU
One who dislike ur video he is definitely jealous with u sir... U r doing a great job for students like me... I m really grateful to u
correct bro
the video was very good
Sir, The way your Explainning, you make complex concept easy for us.Thank u sir
Explicitly discussed thanku Varun sir you are a unique key in India love and respect from Bangladesh ❤❤❤
One of the best video..Easily understand everything from your video. :)
The videos are actually very easy to understand 👏👏
thank you parmish verma!!..great lecture
Thankyou so much sir, Never seen such as teacher like u. We are so lucky to learn from u sir.
Really great tutorial. Excellent teaching skills. Keep it up man...!
Best teaching skills sir..very interested subject
At last I have found a great teacher on RUclips.
Amazing video! Thank you so much!
The great teaching skill you have .....
thankyou sooo much, SIR. i usually don't comment but this time i do need to tell you that you're videos are AMAZING. lots of respect from PAKISTAN.
simply U R AMAZING...SUCH A SHORT EXPLANATION GREAT EXAMPLESS....
itna acha padhate ho sir ki kya bataye , ek he to dil hai kitni baar jeetoge aap.... lots of love from #kanpur #UP
Sir your teaching language is so easy to understand for beginner students
tnx sir for teaching us a good dbms.
Love this topic nd yur teaching style too😊☺️
Thanku so much sir ap k Lecture dekh kr saray concept clear hotay hai.
Very nice explained 👌👌👌👌🙏🙏🚩🚩 जय श्री राम 🚩🚩
amazingly covered the concept....whenever i come here, i always gets get my doubts cleared....Thanks man!!
I want the maximum number of employees from count(dept) what will be the query for this??
What a detailed explanation with examples ....!! 🤩🤩
great teacher ever in my life
thank you sir its really very helpful may Allah help you an every step of your life.
Thanks a lot. Your videos are really helpful.
Thx sir ur teaching techniques are really unique and easy to understand us 👍😊
Good job sir
you are teaching in very simple way than other teacher thanx a lot sir to make this simplest for me
very nice explanation of Group by CLause........thankx .........and upload more videos sir.............
Veere dil khush ho gya acha concept clear hua hai.. Please make series on SQL
Thank you so much...it is really helpful
Sir I went through many courses, but your way of delivery is top notch and exactly the way every students wants, preparing for placements, wish me luck and will definately donate from my first income!!
All the best
@@GateSmashersI want the maximum number of employees from count(dept) what will be the query for this??
Thank you sir for making this video available for free. This helped me and my friends alot for GATE preparation and semester exams❤️❤️❤️
CSE??
So useful Vedio
Cleared all doubt s with this class thank you so much sir🙏
When my teacher explain sql in class
Then feel sleepy
But you are amazing Sir❤️❤️❤️❤️
Watching from Pakistan🇵🇰..... Number 1 teacher of computer studies
❤your teaching! Great explanation ✌🙏
Thank you , your way of teaching is excellent, prayers from Pakistan
Simple English praiseworthy.... awesome
most awesome way to learn SQL keep it up👍
SELECT DISTINCT Dept, Count(*) from Emp group by Dept :)
You just save my day, Thank you Sir..... Love From Pakistan.
Awesome explaination..very helpful for my exams.
Great.....sir...well explained.....thnx varun sir
ah finally someone telling rules as well!!! thank you I was so confused.
You just made SQL queries a piece of cake...
Thank you sir for clarifying the doubts.
Best and best explanation ...
Really nice, clear and to the point video.
excellent teaching techniques..I request if you could be able to make a series with SAS also..
thankk u so much ji...vry nyc tricks....stay blessed...keep it up.
🙏🙏🙏🙏🙏
Nice explanation sir. Thank u.
Bhai I was confused with the subqueries but after watching the video, It help me understand and apply the logic. Thank you so much and Keep inspiring..
Beautifully explained. Thanks a lot
well explained sir please do more videos like this.you actually deseve 1 million subscribers keep up the good work .
Sir your content is very much helpful for us thankyou so much
your teaching is amazing, hatts off man...!!
Very helpful video !!! Nicely explained !!!
Kadak teaching, bhai!
excellent lecture sir!! very useful and easy to understand...gratitude from Bangladesh ....!!
Very nice explanation for a tough topic thanks a ton!
Sir aap bohot aacha explain krte h, thanks
your teaching style is just awsm sir!!!
I have no word , best teacher. I tried many time to understand group by function but Failed! . I just watched for once your video I understand . amazing . love you from Pakistan. My wish to visit India for once and meet you .
Great teaching method.
Respect from kashmir
Hi Varun I must say You are an Excellent Teacher. :)
Sir aik hi dil ha kitni bar jeeto gy 😍❣️💖
great great explanation... thank you
gurujee shandhar jabardast zindabad
select distinct (dept), count(dept) from emp group by dept;
I guess distinct keyword should be used with dept
Hi, Thank you for your videos, you are so clear on presenting
Could you please post few videos on sql functions and how to use them while quering with couple of examples ?
What a superb teaching method
Thank you a thousand crore....🙏🙏🙏love you sir❤️❤️❤️
Just
Love it❤️
Amazing sir.. thank you so much.. gbu..👍
Varun Sir , Apko 1 Mil subscribers takk pohunchane ki full on try karna mein ne ,Lots Lots Love and Thanks from Pakistan
Thank you
I respect simplicity. Your pedagogy is simple and commendable. Keep up the good work bro.
pedo-logy hota hai bhai
@@saifahmed9152 Bro, just check the meaning of pedagogy. I'm requesting this thing in a humble manner.
Best Explanation ever sir