The RANK function assigns a unique numerical rank to each row in a dataset, starting from 1, allowing users to easily identify the first, second, third, or nth highest salary by selecting rows where the rank equals the desired position number.
Installieren Sie unsere Erweiterung an, um sofort in jedem Video zu suchen
Find 1st, 2nd, 3rd Highest Salary with RANK Function #shortsHinzugefügt:
This is the data, salary employees' data, according to descending order of salaries. Now, from here, I want to select first highest salary.
If I provided one, if the ranking is equal to one, first highest salary. If the rank is equal to two, second highest salary. If the rank is equal to three, third highest salary. Rank is equal to four, fourth highest salary. If you want first highest salary, then select the row where the rank is one, first highest salary I will get. If I want second highest salary, select the row where the rank is two, then the second highest salary I will get. But here, one special function I used, rank function. Rank function will give a number, a unique number for every row, starts from one. 1 2 3 4, this is nothing but rank.
Ähnliche Videos
Re: 🗣️📍theprophedu📍2026 GST 103 CLASS (E-EXAM REVISION)
theprophedu
636 views•2026-06-04
WEB TECHNOLOGIES UNIT-2 | Degree 4th sem BCOM Computers web technologies unit-2 full explanation💯✅
LearnwithSahera
1K views•2026-05-29
More tests are always better? How to use AI to identify tests that bring little value
Alliance4Qualification
335 views•2026-05-29
Search Algorithms Explained in 60 Seconds! 🤖💨
samarthtuliofficial
218 views•2026-06-01
People of Game of Thrones using JavaScript DOM
AltCampus
296 views•2026-05-30
Instagram accounts got PWNed
EricParker
13K views•2026-06-03
Introduction to Problem Solving Part - 1 | Lecture 1 | Intermediate DSA
ascensionix
107 views•2026-05-29
So What's Odin Lang Even Good For
TechOverTea
131 views•2026-06-01
