sql satement for 2nd maximum value

Answer Posted / manikandan

select distinct top 2 salary from employee order by salary
desc

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the main use of a namespace?

616


Explain the difference between dispose and finalize()?

636


Tell us how many languages are supported by .net?

595


How can we remove handlers at run time?

639


Name and explain some of the exclusive features which are present in vb?

625






What is the difference between convert.tostring and .tostring() method?

607


What is multiple form in vb?

537


What is the use of internal keyword?

658


How to view an assembly?

675


What are the different types of a stream?

639


What are the differences between vb.net and c#, related to oops concepts

650


Is it necessary to have SQL server installed in your computer in order to create a service based database in vb.net?

1948


What are the technology areas that microsoft.net contains?

645


Explain clr?

649


Explain the use of serialization and deserialization?

611