sql satement for 2nd maximum value

Answer Posted / sunil nandedkar

Select min(Salary)ThirdHighest from employees where salary
in (Select top 3 salary from employees order by salary desc)
For nth replace top 3 with top n

Is This Answer Correct ?    3 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is deep copy?

569


What do you understand by vb.net?

617


Explain the difference between dispose and finalize()?

561


Which dll is used for microsoft .net run time?

557


What is the ruby interface generator?

561






Define manifest?

543


Explain jit?

556


What is the use of errorprovider control?

599


What are the different variables in vb.net?

526


Allowed program to auto-correct the database when loading a presentation.

1753


How to create a constant in vb.net?

605


What is portable executable?

586


How can I extract the formated word(bold,italic,underline,font,color etc) from the msword file.?

598


Using VB, how can you change the Mouse Pointer?

644


Explain the difference between value and reference types?

459