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
- 15616 Views
- GeoTechnology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / mohsin mukri
select max(salary) as Salary from tbl_Employee
where salary < (select max(salary) from tbl_employee)
sory above post ans is wrong bcoz i forgot to remove = sign
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the use of web.config?
Explain cache memory? : Dot net architecture
Define cache coherency? : Dot net architecture
What is Object Caching in Visual Studio 2010?
What does this do? Gacutil /l | find /i "corillian"
Is dim fs as filestreamobject is a managed code? : Dot net architecture
What is the difference between metadata and menifest ?
Explain write back and write through caches? : .NET Architecture
Explain the difference between primary & secondary storage device? : Dot net architecture
What is the procedure on hardware that converts the ascii value to binary? : .NET Architecture
what is diffrent beatween localprinter and networkprinter
Why only boxed types can be unboxed?
12. Types of polymorphisem[Run and Design Exp.]
Explain dma? : Dot net architecture
What is cache coherency? : Dot net architecture
