Horje
2nd highest salary in mysql Code Example
2nd highest salary in mysql 
#2nd Most highest salary using Limit & Order By
SELECT Salary FROM (SELECT Salary FROM Employee ORDER BY salary DESC LIMIT 2) AS Emp ORDER BY salary LIMIT 1;
Source: www.java67.com
how to find 2nd highest salary in mysql 
#2nd Most highest salary using Group By, Order By & Limit clause
SELECT sal FROM emp GROUP BY sal ORDER BY sal DESC LIMIT 1, 1;
how to find 2nd highest salary in mysql 
#2nd Most highest salary using dense_rank()
SELECT sal 
FROM (SELECT dense_rank() over(ORDER BY sal DESC) AS R, sal FROM emp) employee 
WHERE R = 2;
2nd highest salary in mysql 
#Corelated Subquery
SELECT Id, Salary
FROM Employee e
WHERE 2=(SELECT COUNT(DISTINCT Salary) FROM Employee p
WHERE e.Salary<=p.Salary)
Source: www.java67.com



Sql

Related
spring import sql Code Example spring import sql Code Example
where does your database run Code Example where does your database run Code Example
mysql drop trigger Code Example mysql drop trigger Code Example
delete all content in table mysql Code Example delete all content in table mysql Code Example
mysql update table from select on another table Code Example mysql update table from select on another table Code Example

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



 

Horje