select distinct top 2 salary from employee order by salary desc

sql satement for 2nd maximum value

Question Posted / manikandan

Answer Posted / manikandan

select distinct top 2 salary from employee order by salary
desc

Is This Answer Correct ?

3 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What are the technology areas that microsoft.net contains?

555

Explain how does the xmlserializer work?

597

Explain about rapid application development tool?

518

Define cls?

601

What are the differences between server-side and client-side code?

542

Explain the difference between dispose and finalize()?

560

Can you please explain the difference between system.string and system.stringbuilder classes?

548

What is option strict?

522

Tell me which namespace are used for accessing the data?

532

How to execute VB.NET PROJECTS,VB6.0 PROJECTS AND write their test cases.Need Reply Urgently

2005

Explain the use of console application?

539

What is strong typing and weak typing?

548

Why do we use ansi keyword?

575

How to achieve Polymorphism in VB.Net?

624

What is the strong name in .net assembly?

568