answersLogoWhite

0

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

User Avatar

Wiki User

14y 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 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.


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

Find the formula of it.


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


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.

Trending Questions
The constant rate used as a gauge in calculating the valid sample size? What number shows up most often when you roll 10 dice? What is the best online options strategy analysis tool? What is 75.48 rounded to the nearest tenth? How many An NHTSA study found that the average inpatient costs for crash victims who were not using safety belts were percent higher than for those who were belted. A. 15? Whats the biggest bra size? What accounts for the observed differences between samples? How do you calculate a precentage? What does the mean absolute deviation tell you about how spread out the data are? What are the age categories for statistical reporting? What increases the chances of rejecting null hypothesis? Will a population mean and sample mean always be identical? What is the relationship between standard deviation and precision? Economic variables whose values are measured in monetary units are called? How Do you trace a scatter plot? If On a Saturday evening 34 of the people in Chicago go out to dinner 18 see a movie 13 have a party and 35 stay home If seven people are randomly selected what is the probability that one eat? What could be a estimate for 4250? Do qualitative skills include analytical tools such as statistics forecasting risk management and LEAN Six Sigma? What is the average circumference of a woman's hips? What is the probability of rolling a number greater than or equal to 8 with two dice given that at least one of the dice must show a 6?