at 6:09 isnt it pointless to do it with a subquery, you have already ordered them and they are distinct as well, just directly add limit and offset to the subquery and we'll get the answer. Also to fetch nth highest salary, offset should be n-1*
Hi! We have created a video on your request to display domain name. You can check it here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-LtOzjmiJTho.html