Find ✅Nth Highest Salary - SQL [ Commonly Asked SQL Interview Question ]
#sql #sqltips #sqlinterview #sqlinterviewquestions #infosys #accenture #tcs #removeduplicates #milestonecreator #sqltipsandtricks
Hey, Everyone welcome back. So, today in this video we will learn about
" How do I find the details about that employee getting the Nth Highest Salary In SQL ????? "
🟢SQL QUERY USED FOR THIS VIDEO:-
---------------------------------------------------------------------------
CREATE DATABASE TEST;
USE TEST;
CREATE TABLE EMPLOYEE
(
ID Int,
FULL_NAME varchar(50),
SALARY Int
);
INSERT INTO EMPLOYEE (ID,FULL_NAME,SALARY) VALUES (1,'Deepan Kumar',50000);
INSERT INTO EMPLOYEE (ID,FULL_NAME,SALARY) VALUES (2,'Niraj Patel',100000);
INSERT INTO EMPLOYEE (ID,FULL_NAME,SALARY) VALUES (3,'Deepika Naik',70000);
INSERT INTO EMPLOYEE (ID,FULL_NAME,SALARY) VALUES (4,'Ankita KumarI',90000);
INSERT INTO EMPLOYEE (ID,FULL_NAME,SALARY) VALUES (5,'Shreya Naik',54000);
INSERT INTO EMPLOYEE (ID,FULL_NAME,SALARY) VALUES (6,'Shyni Kedia',60000);
SELECT * FROM EMPLOYEE;
--FIND THE DETAIL ABOUT THAT EMPLOYEE WHO IS GETTING N Th HIGEST SALARY ?????
SELECT * FROM EMPLOYEE;
SELECT * FROM
(
SELECT ID,FULL_NAME,SALARY,RANK() OVER (ORDER BY SALARY DESC) AS RANK_No
FROM EMPLOYEE
) T
WHERE RANK_No=n;
----------------------------------------
👋 Additional resources
-------------------------------------------
2nd Highest Salary In SQL - TCS Interview Q & A:-
• 🔎Find 2nd Highest Salary In SQL🔥TCS Interv...
Find Nth Highest Salary - SQL:-
• Find ✅Nth Highest Salary - SQL [ Commonly ...
Infosys SQL Interview Question✅[ Remove Duplicate Records From Table📑In SQL ]:-
• 🔎Find 2nd Highest Salary In SQL🔥TCS Interv...
Top 100 Most Commonly Asked SQL Interview Questions and Answers [ Part-1 ] #sql
• Top 100 Most Commonly Asked SQL Interview ...
Top 100 Most Commonly Asked SQL Interview Questions and Answers [ Part-2 ] #sql
• Top 100 Most Commonly Asked SQL Interview ...
Introduction To SQL Server [ What is Database ]:-
• Introduction To SQL Server [ What is Datab...
What is DBMS || Database Management System [ In Hindi ]:-
• What is DBMS || Database Management System...
What is RDBMS ( Relational Database Management System ):-
• What is RDBMS ( Relational Database Manage...
Database Recovery From MDF And LDF File Using GUI:-
• Database Recovery From MDF And LDF File Us...
2 Methods To Create LOGIN In SQL Server:-
• 2 Methods To Create LOGIN In SQL Server #s...
How To Create a New Login/User In SQL Server:-
• How To Create a New Login / User In SQL Se...
How To Delete/Drop LOGIN In SQL Server:-
• How To Delete/Drop LOGIN In SQL Server #sq...
Complete Guide For Import CSV File To #SqlServer Database (Step-By-Step Along With #ERROR & Solution;-
• Complete Guide For Import #CSV File To #Sq...
🔔 Subscribe to my YouTube channel:-
https://www.youtube.com/channel/UCWfz...
Social Media Link
--------------------------------
LinkedIn:- / deepan-kumar-patel-777591202
Facebook:- https://www.facebook.com/dipan.patel....
---------------------------------------------------------------------------------------------------------
Thanks for watching...
"Milestone Creator"