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 work out the nth term of a sequence?

Find the formula of it.


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 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


How do you find the nth term of an arethmetic sequence?

The nth term is Un = a + (n-1)*d where a = U1 is the first term, and d is the common difference.