Write an SQL query to report the second-highest salary from the Employee table. If there is no second-highest salary, the query should report null.
The query result format is in the following example.
Example 1:
Input:
Employee table:
+----+--------+
| Id | Salary |
+----+--------+
| 1 | 100 |
| 2 | 200 |
| 3 | 300 |
+----+--------+
Output:
+---------------------+
| SecondHighestSalary |
+---------------------+
| 200 |
+---------------------+
Example 2:
Input:
Employee table:
+----+--------+
| Id | Salary |
+----+--------+
| 1 | 100 |
+----+--------+
Output:
+---------------------+
| SecondHighestSalary |
+---------------------+
| Null |
+---------------------+
1. It is simple to get the rank of something using LIMIT However, we won’t pass the test case when there is no SecondHighestSalary - case when the table only has one row.
SELECT salary as SecondHighestSalary
FROM employee
ORDER BY salary DESC
LIMIT 1, 1
To fix this, we want to use SELECT, if there is no second-highest salary, it will return null
SELECT (SELECT DISTINCT Salary
FROM Employee
ORDER BY Salary DESC
LIMIT 1 , 1)AS SecondHighestSalary;
#sqlinterview #sqlinterviewquestionsandanswers #sqlinterviewquestions #sql #mysql #parentchildrelationship #parent #child #relationship #interview #interviewquestions #interviewpreparation #interviewpreperationcourse #SQL #RDBMS #database #bigdata #dataengineering #coding​​ #problemsolving​ #leetcode​ #hackerrank​ #hackerearth​ #algorithms​ #javaprogramming​ #sde​ #placement #programming #java #dsainjava #javaprogramming #coding #coder #placement #array #arrayquestion #arrayjava
#frequentlyaskedquestion #javainterviewquestions #javaprogramming #javaprogrammingtutorial #javainterview #tcsinterview #cognizantinterview #javainterviewquestionsandanswers #javainterviewquestion #javatraining #interviewtraining #interviewquestionsforfreshers #interviews #interview #codeforit #codeitfor #interviewearth #javaprogramming #programmingshorts #youtubechannel
#youtube #youtuber #youtubers #subscribe #youtubevideos#sub#interview #youtubevideo #like #instagram #codeit #coding #javaprogrammingtutorial #mysqltutorials #interviewtips #sqlinterviewquestionsandanswers
how to find 2nd highest salary in SQL,
2nd highest salary in mysql query,
2nd highest salary using limit,
2nd highest salary in sql without subquery,
sql query to find 2nd highest salary,
sql query to find 2nd highest salary of employees in each department,
sql query to find second highest salary of employees,
sql query to find the second highest value in a table,
sql query to find second largest salary,
sql query to find second highest salary using limit,
sql query to find second highest value in a column,
sql query to find nth highest value in a column,
write a sql query to get nth highest salary,
sql query to find the 2nd highest salary,
sql query to get 2nd highest salary,
sql query to get the 2nd highest salary,
sql query to find second highest salary,
sql interview questions and answers,
sql interview questions and answers for freshers,
sql interview questions for freshers,
sql interview asked questions,
hackerrank sql interview questions,
sql interview questions in infosys,
pl sql interview questions,
infosys pl sql interview questions,
virtusa pl sql interview questions,
sql interview notes,
In this channel, we try to solve various Java coding interview questions and basic interview skills.
Our main goal is to share Java and Spring Boot knowledge with the audience.
We will continue to help our audience to prepare and crack JAVA interview programs.
Please Subscribe and Click on the Bell Icon for Regular Updates.