answersLogoWhite

0


Best Answer

Way To Get The Highest Salary From a Table

To Get nth Highest Salary From a Table:

select ename, esal from emp order by esal desc limit (n-1),1;

To Get 5th Highest Salary From a Table:

select ename, esal from emp order by esal desc limit 4,1;

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you find the fifth highest salary in a table?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How int find third highest salary in a table?

find third highest salary in a table


How do you find nth highest salary from table?

select *from emp e where n-1=(select count(distinct sal) from emp e where e.sal >sal);


How do you select seventh highest value?

SINCE THE QUESTION IS NOT SPECIFIC TO FIND 7TH HIGHEST SALARY OF AN EMPLOYEE OR ANYTHING ELSE,LET ME GIVE YOU THE SOLUTION FOR 7TH MAX SAL FROM A EMP TABLE. SELECT * FROM EMP E WHERE 7=(SELECT COUNT(DISTINCT SAL) FROM EMP F WHERE E.SAL<=F.SAL);


How can you find a trend on a table or graph?

which ever bar or table that is the most on a table or bar graph... : ) EX: 10 Is the most on the table , 20 is the highest thing on the bar graph


You can find me in the carbon family in the fifth period?

You are talking about the element nitrogen (N). It is part of the carbon family or group 15 on the periodic table and located in the fifth period.


What is the best way to find the highest paying jobs in Houston?

The best way to find the highest paying jobs available in Houston would probably be Career Builder. They can help one find the type of work they are aiming for and even show them the average salary.


What is the salary of coast guard after next rank?

Military salaries are provided in a table. It is based on the time in service and the current rank. You can find the table at http://www.uscg.mil/ppc/docs/2015basepay.pdf


What much is a 2.5 percent increase for salary?

To find the amount of the increase, multiply the salary by 0.025. To find the new salary, multiply the salary by 1.025


To find the second highest number from a set of numbers?

Find the highest number, eliminate it from the list, find the highest number of the remaining numbers.Find the highest number, eliminate it from the list, find the highest number of the remaining numbers.Find the highest number, eliminate it from the list, find the highest number of the remaining numbers.Find the highest number, eliminate it from the list, find the highest number of the remaining numbers.


Explain how you could search for data in a database and give an example?

To search for data in a database, you can use SQL queries like SELECT * FROM table WHERE condition. For example, to search for all employees named "John" in an employee table, you could use the query SELECT * FROM employees WHERE name = 'John'. This query would return all employees with the name "John" from the employees table.


Where can you find the fifth leader in Pokemon diamond?

You can find the fifth Gym Leader in Hearthome City. Her name is Fantina.


Can i get a high salary job without a diploma?

It is not absolutely necessary to have a diploma or degree for a high salary job, but it is an advantage. Actors and professional athletes are highly paid, but often don't have a formal degree. To find out the highest salary jobs & whether a degree is needed the following website is very informative:http://ca.askmen.com/money/career_150/177_career.html