Second and Third Highest Salary using mysql

It is very easy to find second highest salary

SELECT *
FROM emp
WHERE salary =(SELECT salary
FROM emp
GROUP BY salary
ORDER BY salary DESC
LIMIT 1 , 1)

Third highest salary you can find following ways

SELECT *
FROM emp
WHERE salary =(SELECT salary
FROM emp
GROUP BY salary
ORDER BY salary DESC
LIMIT 2 , 1)


Most Popular

The Requested Url /Phpmyadmin/ Was Not Found On This Server

Image
  What Is phpMyAdmin phpMyAdmin is an open-source software tool introduced on September 9, 1998, which is written in PHP. Basically, it is a third-party tool to manage the tables and data inside the database. phpMyAdmin supports various type of operations on MariaDB and MySQL. The main purpose of phpMyAdmin is to handle the administration of MySQL over the web. phpMyAdmin has a GUI application which used to mange the database. Here we can create a database, table and execution of mysql query using phpMyAdmin GUI Our Problem  : phpMyAdmin url not found. Here you will find the  Solution Here
Keep reading