This is awesome. I tried to use my own approach and then look at how you went about it. I didn't use subqueries but arrived at the same answer. Continue tackling SQL questions for us to learn more from you. Bravo 👍👍
It'd better if we use ranking function for nth highest because there maybe some employees that have the same salary and equal to the highest salary. Thanks a lot for your video!
This is awesome. I tried to use my own approach and then look at how you went about it. I didn't use subqueries but arrived at the same answer. Continue tackling SQL questions for us to learn more from you. Bravo 👍👍
Awesome, I would love to see your approach.
I finally "get" subqueries - thanks for this awesome video!
Not an easy technique to grasp. So you should feel proud!
It'd better if we use ranking function for nth highest because there maybe some employees that have the same salary and equal to the highest salary. Thanks a lot for your video!
Thanks! Yes, you are right. The ranking function is used at the end. I wanted to build up to it cause the syntax is tricking for some:)
when i click link of Dataset, i cannot find it. please help.
I updated the dataset link