Horje
write sql query to find the second highest salary of employee Code Example
write sql query to find the second highest salary of employee 
SELECT MAX(Salary) From Employee
 WHERE Salary < ( SELECT Max(Salary) FROM Employee);
Source: www.java67.com
how to get second highest salary in each department in sql 
SELECT E.Employers_name, E.dep_number, E.salary
FROM Employers E
WHERE 1 = (SELECT COUNT(DISTINCT salary) 
        FROM Employers B 
        WHERE B.salary > E.salary AND E.dep_number = B.dep_number)
group by E.dep_number
sql find second highest salary employee 
/* sql 2nd highest salary employee */
select sal, ename
from emp
where sal =
    (
        select max(sal) from emp where sal <
            (select max(sal) from emp)
    )
----------------------------------------------- option 2
select *
from 
(
    select ename, sal, dense_rank() over(order by sal desc) rank
    from emp
)
where rank =2;



Sql

Related
mariadb number format Code Example mariadb number format Code Example
add colum date in sql Code Example add colum date in sql Code Example
sql display today's date Code Example sql display today's date Code Example
get week day from date in sql Code Example get week day from date in sql Code Example
sql list dates between two dates Code Example sql list dates between two dates Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje