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
What is the median of the lower half of a data set called? How many grams does a 158 pound man weigh? How would you use the mean volumes to find out whether the results are reliable? What would the SQL query be to get the count of customers by city who placed one or more orders? What is the average rate of return from a mutual fund? How many three-quarter pound burgers can be made with 12 pounds of hamburger? What is he probability that the sum of a pair of dice when rolled is six? The sum of 5 numbers is 28 and the sum of their squares is 226 what is the average? What is the population of Tallahassee as of 2008? What does it mean when you have large hands? What is the difference between quota sampling and cluster sampling? What is raw facts or statistics? What is the record for the most children one male has? What circumstances can a small treatment effect be statistically significant? When graphing experimental data which variable goes on the x-asis on a line graph? When a survey of 12 people at a bookstore showed that five had purchased a hardcover book If seven people are selected at random what is the probability that four of them had purchased a hardcoverbook? Is drawing a card from a deck of cards and tossing a coin independent or dependent? What is a mean modemedian? What are the chances of being pregnant if you are 4 days late and a home test came back positive and the next day you were on you period or spotting? What is the standard deviation if P 0.2 and n 400?