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
How many weeks are in 10 years? A student writes a 5 question multiple choice quiz Each question has 4 possible responses The student guesses at random for each question Calc prob for each possible score on the test from 0-5? What is the name for a model that uses numbers to predict what will happen? Does scatter analysis use data that is counted in six sigma? What are the rates for double marker test? 6 In how many ways can the letters in the word SCRAMBLE be rearranged? What is sample trafficking? What should a 5'11 male weigh? A box contains three coins 2 of them fair and one two headed coin select at random tossed twice heads appear both time what is the probability that the coin is two headed? Degrees in a parallelogram? How many times would a coin have to show heads in 50 tosses to show an experimental probability of 20 percent more than the theoretical probability of getting heads? What is a non example of independent variable? What is the difference between Shrinkage and attrition? What is largest 3 digit number that can be divided by 15 25 and 60? What 5 -step Composite risk management? people who must memorize a lot of information and remember it for a long time, are relying on the ______more than most people? In which step would you quantify risk cost and time? If there are 25 values in a data set in order from smallest to largest what is the third quartile of the data set? What is the mean median and mode of 60 70 75 78 80 80 83 85 87 90 90 90 90 93 95 95 98 100? Does the hollister website give you a sizing chart?