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

Which dll is used for microsoft .net run time?

942

what is common language specification?

935

How do you define a read only property in a class module?

896

Before in my vb app I would just load the icons from dll. How can I load the icons provided by .net dynamically?

940

Explain namespace?

1046

What is sealed class?

1088

Explain the use of console application?

937

How to retrieve images in sql server database through vb.net?

939

Explain the difference between an xml "fragment" and an xml "document."

869

How to run a dos command in vb.net?

998

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

2470

what is intermediate language?

985

Explain about rapid application development tool?

912

Explain the difference between .dll extension and .exe extension files?

1012

What is deep copy?

899