SQL query for Second Highest Salary
SELECT MAX(salary) FROM Employee WHERE Salary NOT IN ( SELECT Max(Salary) FROM Employee);
SELECT Id, Salary FROM Employee e WHERE 2=(SELECT COUNT(DISTINCT Salary) FROM Employee p WHERE e.Salary<=p.Salary)
WebinBangla is a leading web solution provider and we work globally. Wel make sure our clients and customers avail maximum benefits by using our high quality services and complete packages.
- Address: Pahartoli, Raozan, Chittagong.
- Email: email@example.com
- Phone: +880 1738 914871
- Monday - Friday - 9am to 5pm
- Saturday - 9am to 2pm
- Sunday - Closed