answersLogoWhite

0

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

15y ago

What else can I help you with?

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


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

select name,position,salary from PERSON where PERSON.salary <=10000 Find all peoples name job position and salary in the table PERSON where the salary is a meager 10000 or less, then give em a pay rise.


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.


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


Where can you find the fifth leader in Pokemon diamond?

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

Trending Questions
Is geometric probability hard? What is the probability of rolling a die and getting a number less than 5 on a single roll? Define line graph? Difference between independent and dependent events? What identifies the quality of the data? What do the tems frequent likely occasional seldom and unlikely referr to on the risk assessment matrix? Where should the regression and correlation analysis be put in a thesis? Why are stem and leaf plots a good way to show data? How is indexing faster than sorting when accessing data from a table? How many tornadoes hit stephensville Texas? After a movie premiere 99 of the first 130 people surveyed said they liked the movie what is the experimental probability that the next person surveyed will say he or she liked the movie? How do you find the mean and median for dichotomous data types? If Two dice are rolled Find the probability of getting a sum greater than 8? What is the probability that you will roll an even number on a number cube numbered 1 to 6? Why is the random assignment of individuals to experimental and control groups important for an experiment? How long does a period end? What is the probability of one head and two tails? If the probability that an event will occur is three eighths then what is the probability that the event will not occur on the first trial and not occur on the second trial? What is the likelihoodof an event occurring? The suggested interval size of the class intervals for a histogram can be estimated by?