2nd Highest Salary || Nth Highest Salary || LIMIT keyword in SQL

2nd Highest Salary || Nth Highest Salary || LIMIT keyword in SQL - Part 4

Рет қаралды 33,698

5 жыл бұрын

In this video, we will learn about how to find out 2nd highest salary and how to write a generic query to find out the nth highest salary from a table.
Learn:
-What is Max() function
-What is LIMIT Keyword
-How to find out 2nd highest salary using inner query and Max() function
-How to find out nth highest salary using LIMIT keyword
--What is TOP and ROWNUM in SQL.
~~~Subscribe to this channel, and press bell icon to get some interesting videos on Selenium and Automation:
kzfaq.info%20Au...
Follow me on my Facebook Page:
/ naveenqtpexpert
Let's join our Automation community for some amazing knowledge sharing and group discussion on Telegram:
t.me/joinchat/COJqZUPB02rRd8w...
WebServices API Automation Tutorials:
vimeo.com/ondemand/webservice... Subscribe to this channel, and press bell icon to get some interesting videos on Selenium and Automation:
kzfaq.info%20Au...
Follow me on my Facebook Page:
/ naveenqtpexpert
Let's join our Automation community for some amazing knowledge sharing and group discussion on Telegram:
t.me/joinchat/COJqZUPB02r5sB7...
Paid courses (Recorded) videos:
Java & Selenium Course: www.naveenautomationlabs.com/p...
API Course: www.naveenautomationlabs.com/p... ➡️Get Our Courses✔️
📗 Get My Paid Courses at
Paid courses (Recorded) videos:
Java & Selenium Course: www.naveenautomationlabs.com/p...
API Course: www.naveenautomationlabs.com/p...
-------------------------------
✔️SOCIAL NETWORKS
Facebook: / naveenqtpexpert
Twitter: / naveenkhunteta
Blog: www.naveenautomationlabs.com
--------------------------------
Support My Channel✔️Or Buy Me A Coffee
Paypal: paypal.me/naveenkhunteta
Google Pay: naveenanimation20@gmail.com
--------------------------------
✔️Thanks for watching!
देखने के लिए धन्यवाद
Благодаря за гледането
感谢您观看
Merci d'avoir regardé
Grazie per la visione
Gracias por ver
شكرا للمشاهدة

Пікірлер: 22

@kavyahc2205 5 жыл бұрын

Thank you...Very nice explanation.... Very useful... I have asked about this fetching highest column in my recent interview...

@sristipattar7651 5 жыл бұрын

👍💐Informative video.

@arunpondhe7949 5 жыл бұрын

superb Explanation Thank You for guidance

@KrishnaPrasad-id1mp 4 жыл бұрын

Hi Naveen, Thanks for these videos. Kindly upload Foreign Key Constraint, Joins videos also.

@pradeepbisht7346 5 жыл бұрын

thx naveen@@ plz make some interview question for ma nual testing@@

@meenup7232 5 жыл бұрын

Hi Naveen, Thank you for such a nice video. just wanted to know how to write LIMIT command for second last salary for employee if we dont know the total number of rows .

@gayatriganyarpwar2090 5 жыл бұрын

Very nice and informative video. Could you please share video on joins. It will be of great help.

@hitiknegi6808 3 жыл бұрын

awesome :-)

@rekhachawla459 4 жыл бұрын

Hello sir, i saw your SQL and automation videos they are really useful.sir i want you to make some videos on joins and other SQL queries that are asked in interviews

@naveenautomationlabs 4 жыл бұрын

Sure I'll release them very soon.

@push_freebird6693 Жыл бұрын

very nice vedio very helpful need joins vedio too!!!

@jatinpatel7443 3 жыл бұрын

Hi Naveen, you are doing amazing videos for all series . thank you for sharing you knowledge . how can i get this SQL note ?

@nalinaksheepanda1596 5 жыл бұрын

I think, LIMIT is only supported for MySQL, I tried in Oracle 11g, it gives me error. In Oracle we can write following query to find nth salary, By Using function DENSE_RANK() : select * from ( select salary ,dense_rank() over (order by salary desc) ranking from employees ) where ranking = n ; OR By Using Co-related Subquery : select distinct salary from employees a where n = (select count(distinct(salary)) from employees b where b.salary >= a.salary) order by a.salary desc;