Great video! Kudos to you, sir! Just a few corrections though: 1. Instead of SELECT DISTINCT(COUNT Salary) FROM Emp; , the query should be SELECT COUNT(DISTINCT Salary) FROM Emp; 2. Similarly, instead of SELECT DISTINCT(SUM Salary) FROM Emp; , the query should be SELECT SUM(DISTINCT Salary) FROM Emp; , and 3. Instead of SELECT DISTINCT(AVG Salary) FROM Emp; , the query should be SELECT AVG(DISTINCT Salary) FROM Emp;
It was a great video to learn SQL, Between kindly correct your query expression at time 6:17 to SELECT COUNT(DISTINCT(salary)) FROM employee; Thank you.
I came across ur videos. And I swear u made my life easier. I wanted to join SQL classes, however couldn't join right now due to financial condition.. And I started following ur videos. I don think I need any coaching outside. Thanks sir.
7 lakh views only 20k likes...guys if you gain something from these videos don't br thats selfish do like for this man he is working hard for us...he will gain something from us if we do like and subscribe....
It was a great video to learn SQL, But in this video kindly correct your query expression at time 6:17 to SELECT COUNT(DISTINCT(salary)) FROM employee;
I watch all of your videos and you are a saviour! You make us understand complex concepts in easier way,thanks a ton! I recommend your channel to my friends and they love it too:)
Bipul Kumar 1 year ago It was a great video to learn SQL, Between kindly correct your query expression at time 6:17 to SELECT COUNT(DISTINCT(salary)) FROM employee; Thank you.
Rahul Kushwaha 1 year ago select sum ( distinct ( salary ) ) from emp; cos first we have to distinct the data and then we want the sum of that distinct data. 9
Great content, no doubt on that! !! but the only problem I usually face is that videos are not in sequence in playlist, in this playlist also after Lec -50 there is direct Lec-55 andI couldn't find Lec-51 in this playlist. This is the same reason I left in between the 'Computer Organization' series..
Great video! Kudos to you, sir!
Just a few corrections though:
1. Instead of SELECT DISTINCT(COUNT Salary) FROM Emp; , the query should be SELECT COUNT(DISTINCT Salary) FROM Emp;
2. Similarly, instead of SELECT DISTINCT(SUM Salary) FROM Emp; , the query should be SELECT SUM(DISTINCT Salary) FROM Emp; , and
3. Instead of SELECT DISTINCT(AVG Salary) FROM Emp; , the query should be SELECT AVG(DISTINCT Salary) FROM Emp;
Yeah I also able to figured it out as I was doing practical side by side
thnx ,
true
yeah faced the same thing while practicing and was about to comment the same
Thanks for sharing
It was a great video to learn SQL, Between kindly correct your query expression at time 6:17 to SELECT COUNT(DISTINCT(salary)) FROM employee; Thank you.
Thanks
@@janvinaik5072 hey it's good to see an army here
@@mallikarjunpidaparthi ohh heyy!!!!!
@@mallikarjunpidaparthi army??
@@janvinaik5072 yes I am
One of the best TH-cam channels for engineering and computer science students.👌👌
I came across ur videos. And I swear u made my life easier. I wanted to join SQL classes, however couldn't join right now due to financial condition.. And I started following ur videos. I don think I need any coaching outside. Thanks sir.
You're right bro
Trueee..,😍
6:40 SELECT COUNT( DISTINCT Salary) FROM Emp; is the correct answer.
ooh bro thanks i was also confused when it didnt worked
Sir you deserve to be a best youtuber according to me you explaining topic very easily
select sum ( distinct ( salary ) ) from emp;
cos first we have to distinct the data and then we want the sum of that distinct data.
Yes I have same problem with that....
We need to distinct salary then take sum.
th-cam.com/video/5FsIa4Mp3ho/w-d-xo.html
good bro....I also face the same problem and bcz of u it solve
I got Alpha in OS by understanding concepts from videos of sir now I am studying DBMS and now I again came back to sir lectures
You are a great teacher...much appreciated...thanks...no technical background required to understand your explanation..
Thank you so much for all your hard work!!! We really appreciate it!!
select count(distinct(dept)) from emp;
This is the correct one thanks
7 lakh views only 20k likes...guys if you gain something from these videos don't br thats selfish do like for this man he is working hard for us...he will gain something from us if we do like and subscribe....
One question but the answer providing with complete details , that's superb. Thank you so much sir
Bro kuch bhi hai pr aapne har ek aggregate ko har tarh ki situation se bta hai thanku bro ❤️
All of ur videos are easily understandable ... Punjabi's are lit
It was a great video to learn SQL, But in this video kindly correct your query expression at time 6:17 to SELECT COUNT(DISTINCT(salary)) FROM employee;
I watch all of your videos and you are a saviour! You make us understand complex concepts in easier way,thanks a ton! I recommend your channel to my friends and they love it too:)
Bhai maza aa gaya aapse padh kr. sab log bhai ka channel subscribe kro aur bell dabana na bhulna🙏🙏🙏
Great video. It's like learning SQL in the easiest way possible. It is only possible by a great Teacher like Singla Sir. Thank you, sir.
Wow tusi great ho sir bohat acha andaz Hy parhanay ka keep going bro
Thank You. Keep learning and sharing
select sum(distinct(salary) )from emp; will actually give sum of distinct salaries.
PADHAKU BACCHE 🙃
Respected sir... You are really great...getting the concept clearly
So nice ,
This tutorial beneficiate me more detailing...
thanks dear
Sir aap logic ko bahut hi acche sai samjhate ho. Great job.
you look cute so this maintains my intrest in the topic 😂😂
wah
Yha sakht launda pighal gya
padhai kr lo pagal aurat, jahan accha ladka dikha ni ki line maarna start
@@AnkitKumar-bh8jr 😂
true😀
i really appreciate ur videos. They helped me alot in clearing my concepts thanks for such good stuff
Super se bahut uper sir ..thanks alot ...
i think correct syntax is -.> SELECT count (DISTINCT salary) FROM emp; thanks for videos sir
yes bro you are right
You way of teaching is outstanding sir😊
Couldn’t get my head around this in classes thanks for your help
Very nice, km time m jyada fayda🙏 I like uhhh
You are the best teacher in my life.
Very Very Nice Teaching Sir ,thank you so much.
Love from Pakistan 🇵🇰❤️
Great work sir 😊
Bipul Kumar
1 year ago
It was a great video to learn SQL, Between kindly correct your query expression at time 6:17 to SELECT COUNT(DISTINCT(salary)) FROM employee; Thank you.
Detailed explanation. Thank you.
You will always remain in my youtube subscribed list.
Add to favorite explaination✌️
Happy Gupta ! Thank you
@@GateSmashers your welcome sir
Thank you so much sir Bahut hi achhi series hai ❤️🙏
Channal deserves 1M
Sir, you are the best. Your videos helped me a lot. Thank you
Rahul Kushwaha
1 year ago
select sum ( distinct ( salary ) ) from emp;
cos first we have to distinct the data and then we want the sum of that distinct data.
9
Aapko jitna bhi Thanks kahe autna kum he sir
Thanks you sir for this video.. Tomorrow is my presentation in our class... And your video is very helpfull really2 thanks sir..
Thanks you, sir aap bhaut he aaram aaram se samjhte ho to sab ek baar me samaj a jata h.... Again thank you!!
When I start watching your videos ...I automatically continued to watch one by one 😂😊
I cant understand Hindi much, still i was able to get the idea in depth. thank you soo much for explaining in a simple way. keep going
Thank you so much for all your videos. It is easy to understand
Great content, no doubt on that! !! but the only problem I usually face is that videos are not in sequence in playlist, in this playlist also after Lec -50 there is direct Lec-55 andI couldn't find Lec-51 in this playlist. This is the same reason I left in between the 'Computer Organization' series..
Yes this is my problem also
really so helpful ...thank sir.
Thanks a lot sir for such a understansting teaching 😊
U r perfect trainer 👍thank u
Thank you..sooo much sir
Excellent teaching
Excellent explanation sir.... Love ur videos
I don't know how to thank you for this quality education 🔥❤️🙏
You can share ,subscribe,like,to thank 😂
thank you sir for make this easy video for us
Thanks brother, From Bangladesh ❤❤😊
Thank you sir for teaching us and keep going
You are a gem 💎
You are our savior
Great vedio sir thanks you sir
You are so hardworking
Keep it up
Nice sir bhut easy way mai smjha diye
Hello Sir , Your videos are too good . Please make videos on sql network traffic
Thank you bhaiya for this amazing explanation!
It will be select count(distinct sal) from emp; at 6:15
JAZAK Allah sir
Thanku😊😊😊😊😊😊
Sir aapse bdiya sql koi nhi smja skta
Sir u r great God bless u inshaAllah
The best teacher 😭❤❤❤❤
Now I will definitely score well in university exam. Thanks sir
Sir you are Great , Excellent explanation
thnkk u so much sir..i m the biggest fan of u ...really..
it was a great person and each in every ponit.
Thank you so much sir for making these videos🙏🙏🙏🙏
thank u so much Bro , Gr8 eforts for us
love you sir 900❣❣
Thank you so much . Ur videos helped me a lot
Very good explanation of count sir
Thank you sir you are awesome
Bhot acha samjhaya bhaiya apka
Subscribe krna toh bnta h😁👍
Sir aap bohot accha padhate ho
Super bro Ur teaching
Nice explanation 👍
Excellent ☺️👍 teaching 🎉
U r genius sir actually 👍👍👍👍👍👍👍👌👌👌👌👌👌
Sir Quarantine mein GATE 2021 ke liye aap hi sahara hai. Thank you ji.
Thank you so much sir, this video really helped me understand aggregate functions!
Sir ne employee table me apni salary sabse zada likhi h 🤣🤣🤭🤭🤭
Salary is in dollars
@@pavankulkarni7431 I don't bro 😅
th-cam.com/video/5FsIa4Mp3ho/w-d-xo.html
great work sir...!
Sir main kavi school me nii samjha but aap bhut acha samjhaye thank you sir
Accha kam kar rahe ho bhai aap
bohot aage jaoge bro aapp......
Thnku so much sir this video is very helpful for me 🙏🙏🙏
Thanks Sir Same Question Ask in Parul University Exam🙏🙏
Thank you so much from the side of people who are watching this video just before their 12th Board exam!
Simply super bro TQs
Very helpful bhai
superb teaching sir ji
Thanks for the easy explanation🙂
Sir thank you for helping student ❤❤❤