how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?
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 |
Post New Answer View All Answers
What does the term "green architecture" mean? : .NET Architecture
How to implement the display in the class printdoc (how to resolve the naming conflict) a: no naming conflicts
how to change the title of my window?
Explain dma? : Dot net architecture
Explain .net mobile selectionlist control? : Microsoft dot net mobile
What is .net mobile lists. : Microsoft dot net mobile
What is difference between Desktop, Client Server & Web based applications?
What are .net mobile controls features? : Microsoft dot net mobile
Explain cache memory? : .NET Architecture
What is IL code, CLR, CTS, GAC & GC?
What is the purpose of cache? : Dot net architecture
can u give me real example of how web.config overrides the machine.config file?
how to change row background color in gridview
Explain difference between machine config vs. Web config : Dot net architecture
Define a virtual memory? : Dot net architecture