SQL Query to find Nth highest salary in Oracle using ROW_NUMBER function?

#kkjavatutorials

About this Video:
In this video, we will learn how to write an SQL Query to find the Nth highest salary in Oracle using ROW_NUMBER function?

Follow me on Social network:

KK JavaTutorials WebSite:

Subscribe KK JavaTutorials YouTube Channel:

Subscribe My Hindi Channel(KK HindiGyan):

Some Important Playlist link on KK JavaTutorials:

Spring Framework Tutorial:

Eclipse shortcuts :

Java 8 Features Tutorial(All In One):

JDBC Tutorial in depth[Must Watch]

Java 8 Stream APIs:

WebLogic Server Tutorials:

Spring Boot Tutorial(All In One):

Hibernate Tutorials:

Java 5 new features Tutorials

Java 7 Features tutorials:

Java multithreading for beginners:

Java Collections framework Tutorials:

OOPs concepts in java Tutorials:

Design Pattern Tutorials:

Git & GitHub Tutorials:

Git & GitHub Interview Questions:

Jenkins Tutorials

Notepad++ Tutorials

CoreJava basic Interview Questions and Answers

Java array programming interview questions

Core Java Basics Tutorials

Java Programming problem-Solving Interview Questions

Searching Algorithms

Sorting Algorithms

Custom Stack

Custom Linked List

Multi-Threading Programs

Binary Tree & Binary Search Tree

Gradle Tutorials:

[chetanbhandari]

Thnx for video pls create microservices series

[anilgadekar]

Hi sir, when I use this ROW_NUMBER() function in mysql it work for me to display all records,
>select s. *, ROW_NUMBER () OVER(order by fees DESC) as rownum from student s;
But problem here is if we want to find second largest fees from table using Bellow query then I will get error,
> select * from (select *.s, ROW_NUMBER() OVER(ORDER BY fees desc) as rownumber from student s) where rownumber=2;
Can you please clear my doubts sir?

[Pgswapgjjhgghh]

If there is duplicate salary then It will not work it is better to use dense_rank