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 / sathish
select max(Salary)from employee where Salary not in (select
max(Salary)from employee )
select min(Salary)from employee where Salary not in (select
min(Salary)from employee )
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form. What is the exact procedure. : Dot net architecture
Explain different pipelining hazards and how are they eliminated? : .NET Architecture
how we can fire event in databound column in datagrid without using button?
How can I create a application?
5. Wcf- Session Managment
What is a virtual memory? : .NET Architecture
Different types of authentication modes in .net framework ?
Is .net easier than java?
what is polymorphism and advantage ?
Explain hard disk and what is its purpose? : Dot net architecture
Can you explain control extenders?
Describe the Managed Execution Process in .NET?
Explain Intermediate Language?
Can I create my own context attributes?
What is the procedure on hardware that converts the ascii value to binary? : .NET Architecture