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.
Install our extension to search inside any video instantly.
Find 1st, 2nd, 3rd Highest Salary with RANK Function #shortsAdded:
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.
Related Videos
Agentforce NOW AMA: Build with React and Salesforce Multi-Framework
SalesforceDevs
490 views•2026-05-28
How agent o11y differs from traditional o11y — Phil Hetzel, Braintrust
aiDotEngineer
450 views•2026-05-28
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
Introduction to Problem Solving Part - 1 | Lecture 1 | Intermediate DSA
ascensionix
107 views•2026-05-29
🚀 BCS613C Compiler Design | Module 1 to 5 Schema Evaluation 🔥 | VTU 6th Sem 💯 #VTU #bcs613c #exam
Pranavaa-y4y
104 views•2026-06-02
