answersLogoWhite

0

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

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

How do you find the fifth highest salary in a table?

Way To Get The Highest Salary From a TableTo 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;


What is the nth term of 04163664?

It is not possible to find the nth term from the given information.


How can you find the nth partial?

The Nth partial sum is the sum of the first n terms in an infinite series.


How do you find the nth term in maths?

my nth term maths is very tuff because its syallabus is changed


Why do you have to minus to find the nth term?

You don't.


Where can you find gold in Texas?

209 nth ash


How do you find the nth term?

Say if you had the pattern 15 20 25 30 35 40 45 50 To find the nth term you have to see what the gap between the numbers is. In our case this is 5. Then you have to find out what the difference between the gap and the first number. In this sequence it is 10. So your answer would be..... 5n+10 That's how you find the nth term.


How do you work out the nth term of a sequence?

Find the formula of it.


How do you find the nth root of a number?

You seem to be unaware of the fact that you can obtain the answer easily by using the scientific calculator that comes as part of your computer. In general the nth root is extremely difficult to find.


What is the nth term for 5 11 17 23 29?

35 * * * * * That is the next term. The question, however, is about the nth term. And that is 6*n - 1


Find nth term of 0 5 10 15 20?

5n-5, because its the 5 time table (called 5n) minus 5 each time


What is the nth term for 3 10 17 24 31?

You can see that all the numbers go up by 7. This means that the first part of the nth term rule for this sequence is 7n. Now, you have to find out how to get from 7 to 3, 14 to 10, 21 to 17 ... this is because we are going up in the 7 times table. To get from the seventh times table to the sequence, you take away four. So the answer is : 7n-4

Trending Questions
What is a z-score? How many digits are needed to create a number in the hundred millions? How the evidence from a data table supports a hypothesis? How much is statius on recklesspk an rsps? What is reasonable explanation for the large gap in histogram? What is the tally for histogram? Will someone with high IQ live longer than someone with low IQ? How is a line graph similar to a bar graph? There is a bag of marbles 10 are red 15 are purple and 25 are yellow what is the probability of picking a purple marble? When we have more data points what effect will this have on our mean? What kind of data can be use on a bar graph? Is this independent variable or dependent Students of different ages were given the same puzzle to assemble The puzzle assembly time was measured? What is difference between measurement and estimation? What is similar to an anecdote? What does it mean for a population to be normally distributed? In a batch of 1160 calculators 5 were found to be defective. What is the probability that a calculator chosen at random will be defective Write the probability as a percent. Round to the nearest tenth? What determines the size of the pieces of a pie chart in excel? 10000 to invest in a stock portfolio. stock A expected return 18 and stock B expected return 11. create a portfolio with expected return of 16.25. how much to invest in stock A and stock B? Advantages of double bar graph? You toss two dice 1000 times How many times do you expect to have the sum of the two dice equal to 7?