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
- 12504 Views
- GeoTechnology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / arrry.net
SELECT * FROM employee
WHERE Salary=(SELECT max(Salary)
FROM employee WHERE Marks< (SELECT max(Salary) FROM
employee));
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Explain .net mobile input controls? : Microsoft dot net mobile
What size is a .net object?
Explain dma? : .NET Architecture
Explain about microsoft visual studio?
How resource files are used in .net?
So what exactly is the configuration file for then?
Explain the difference between l1 and l2 cache? : .NET Architecture
How do I write to the application configuration file at runtime?
How will you do windows authentication and what is the namespace?
12. Types of polymorphisem[Run and Design Exp.]
any one can explain about projectarchitecture and project approach briefly
What is .net viewstate?
how to delete the record using data reader
What is cache coherency? : Dot net architecture
What does the term "green architecture" mean? : .NET Architecture
