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

Подписаться 51 тыс.

Просмотров 8 тыс.

50% 1

#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?
Blog Link :kkjavatutorial...
Follow me on Social network:
Facebook: / kkjavatutorials
Twitter: / kkjavatutorial1
Instagram: / kkjavatutorials
KK JavaTutorials WebSite:
kkjavatutorial...
Subscribe KK JavaTutorials RU-vid Channel:
/ kkjavatutorials
Subscribe My Hindi Channel(KK HindiGyan):
bit.ly/2AL1ub6
Some Important Playlist link on KK JavaTutorials:
Spring Framework Tutorial:
bit.ly/2F0Fltx
Eclipse shortcuts :
bit.ly/2QiL27j
Java 8 Features Tutorial(All In One):
bit.ly/2OnKmf5
JDBC Tutorial in depth[Must Watch]
bit.ly/2Ou5sso
Java 8 Stream APIs:
bit.ly/2RwPBek
WebLogic Server Tutorials:
bit.ly/2SIuV4x
Spring Boot Tutorial(All In One):
bit.ly/2P8PJ7f
Hibernate Tutorials:
bit.ly/2QiZI6r
Java 5 new features Tutorials
bit.ly/2SKCV59
Java 7 Features tutorials:
bit.ly/2ALPoP4
Java multithreading for beginners:
bit.ly/2PGIpyW
Java Collections framework Tutorials:
bit.ly/2zqeEs5
OOPs concepts in java Tutorials:
bit.ly/2QgUdF9
Design Pattern Tutorials:
bit.ly/3fg9tz2
Git & GitHub Tutorials:
bit.ly/2W21tKi
Git & GitHub Interview Questions:
bit.ly/3c5UAgC
Jenkins Tutorials
bit.ly/2XftJcR
Notepad++ Tutorials
bit.ly/2PahY2L
CoreJava basic Interview Questions and Answers
bit.ly/3k6Hc0q
Java array programming interview questions
bit.ly/2PgWCkd
Core Java Basics Tutorials
bit.ly/3geI1C1
Java Programming problem-Solving Interview Questions
bit.ly/39Gg4jO
Searching Algorithms
bit.ly/317C5nO
Sorting Algorithms
bit.ly/33bdZv9
Custom Stack
bit.ly/39JQDxL
Custom Linked List
bit.ly/3hT4JzO
Multi-Threading Programs
bit.ly/3gf16DT
Binary Tree & Binary Search Tree
bit.ly/2CWoW9n
Gradle Tutorials:
bit.ly/3afIaCK

Опубликовано:

29 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 4

@Pgswapgjjhgghh8283 Год назад

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

@electricalsir 8 месяцев назад

yes you right

@anilgadekar3036 3 года назад

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?