Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?
- 11 Answers
- 15738 Views
- GeoTechnology, Wipro, I also Faced
- E-Mail Answers
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
Can I customise the trace output?
Tell me .net mobile emulators? : Microsoft dot net mobile
What is ILDASM ?
How can I write my own .NET host?
The maximum report processing jobs limit configured by your system administrator has been reached.How I can Solve this problem when i using crystal report to load from my application.
What is the use of TPL DATAFLOW?
Why only boxed types can be unboxed?
Xmlserializer is throwing a generic "there was an error reflecting myclass" error. How do I find out what the problem is?
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
What is the access level of the visibility type internal?
How do I write to the application configuration file at runtime?
server.transfer limitation ?
What is cache coherency? : Dot net architecture
Explain the purpose of cache? How is it used? : .NET Architecture
What is the difference between an application and a program?
