select max(amt)as amt from EmployeePaymentDetails where amt< (select ma

how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?

Question Posted / deepak

Answer Posted / deepak

select max(amt)as amt from EmployeePaymentDetails where amt<
(select max(amt)as amt from EmployeePaymentDetails)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What does the term "green architecture" mean? : .NET Architecture

1024

How to implement the display in the class printdoc (how to resolve the naming conflict) a: no naming conflicts

1110

how to change the title of my window?

1941

Explain dma? : Dot net architecture

1073

Explain .net mobile selectionlist control? : Microsoft dot net mobile

1027

What is .net mobile lists. : Microsoft dot net mobile

987

What is difference between Desktop, Client Server & Web based applications?

1098

What are .net mobile controls features? : Microsoft dot net mobile

999

Explain cache memory? : .NET Architecture

1026

What is IL code, CLR, CTS, GAC & GC?

1085

What is the purpose of cache? : Dot net architecture

1044

can u give me real example of how web.config overrides the machine.config file?

1842

how to change row background color in gridview

1035

Explain difference between machine config vs. Web config : Dot net architecture

955

Define a virtual memory? : Dot net architecture

956