🔎Find 2nd Highest Salary In SQL🔥TCS Interview Q & A

#sql #sqltips #sqlinterview #sqlinterviewquestions #infosys #removeduplicates #milestonecreator

Hey, Everyone welcome back. So, today in this video we will learn about
" How do I find the details about that employee who is getting the 2nd highest salary ????? "

🟢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 2ND HIGEST SALARY ?????

SELECT * FROM EMPLOYEE;
SELECT ID,FULL_NAME,SALARY
FROM EMPLOYEE
WHERE SALARY =
(
SELECT MAX(SALARY) FROM EMPLOYEE
where salary (USE GRATER THEN SYMBOL)
(SELECT MAX(SALARY) FROM EMPLOYEE
WHERE SALARY (USE GRATER THEN SYMBOL)
(SELECT MAX(SALARY) FROM EMPLOYEE))
) ;

-----------------------------------------
👋 Additional resources
-------------------------------------------
2nd Highest Salary In SQL - TCS Interview Q & A:-
https://youtu.be/JAX5JuP2gac

Infosys SQL Interview Question✅[ Remove Duplicate Records From Table📑In SQL ]:-
https://youtu.be/KfTimKa2lTk

Top 100 Most Commonly Asked SQL Interview Questions and Answers [ Part-1 ] #sql
https://youtu.be/RTqAL0Tro2k

Top 100 Most Commonly Asked SQL Interview Questions and Answers [ Part-2 ] #sql
https://youtu.be/kAXN2oWrNXo

Introduction To SQL Server [ What is Database ]:-
https://youtu.be/12icOAP8NkI

What is DBMS || Database Management System [ In Hindi ]:-
https://youtu.be/yRxIImQMi7U

What is RDBMS ( Relational Database Management System ):-
https://youtu.be/RkEVbs4-W_s

Database Recovery From MDF And LDF File Using GUI:-
https://youtu.be/jqkkc7Gl5Lk

2 Methods To Create LOGIN In SQL Server:-
https://youtu.be/l2BRgwr5ZjM

How To Create a New Login/User In SQL Server:-
https://youtu.be/wF-agvjfk-E

How To Delete/Drop LOGIN In SQL Server:-
https://youtu.be/PH89xFVvLxI

Complete Guide For Import CSV File To #SqlServer Database (Step-By-Step Along With #ERROR & Solution;-
https://youtu.be/1OgIy7Ji5TE

🔔 Subscribe to my YouTube channel:-
https://www.youtube.com/channel/UCWfz...

Social Media Link
--------------------------------
LinkedIn:- https://www.linkedin.com/in/deepan-kumar-patel-777591202
Facebook:- https://www.facebook.com/dipan.patel.94402?mibextid=2JQ9oc
---------------------------------------------------------------------------------------------------------
Thanks for watching...
"Milestone Creator"

Видео 🔎Find 2nd Highest Salary In SQL🔥TCS Interview Q & A канала MilEstOne CrEaTor