How To Find Second Highest Salary Of An Employee?

1.	How To Find Second Highest Salary Of An Employee?
Answer» There are many ways to find second HIGHEST salary of Employees in SQ. You can either use SQL JOIN or Subquery to solve this PROBLEM. Here is SQL QUERY using Subquery : Select MAX(Salary) from table1 WHERE Salary NOT IN ( select MAX(Salary) from table1. There are many ways to find second highest salary of Employees in SQ. You can either use SQL Join or Subquery to solve this problem. Here is SQL query using Subquery : Select MAX(Salary) from table1 WHERE Salary NOT IN ( select MAX(Salary) from table1.

Answer»

There are many ways to find second HIGHEST salary of Employees in SQ. You can either use SQL JOIN or Subquery to solve this PROBLEM.

Here is SQL QUERY using Subquery :

Select MAX(Salary) from table1 WHERE Salary NOT IN ( select MAX(Salary)

from table1.

There are many ways to find second highest salary of Employees in SQ. You can either use SQL Join or Subquery to solve this problem.

Here is SQL query using Subquery :

Select MAX(Salary) from table1 WHERE Salary NOT IN ( select MAX(Salary)

from table1.

Discussion