1st 2nd highest 3rd highest salary in mysql

FIRST HIGHEST SALARY
SELECT emp_id, emp_name, emp_email_id, emp_salary  FROM employee_list ORDER by emp_salary Asc LIMIT 1, 1
SECOND HIGHEST SALARY
SELECT emp_id, emp_name, emp_email_id, emp_salary  FROM employee_list ORDER by emp_salary Asc LIMIT 1, 1
THIRD HIGHEST SALARY
SELECT emp_id, emp_name, emp_email_id, emp_salary  FROM employee_list ORDER by emp_salary Asc LIMIT 1, 1









Comments

Popular posts from this blog

ARRAY