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
- 16074 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 domestic architecture artifacts? : Dot net architecture
What is a managed code is dim fs as filestreamobject is a managed code? : .NET Architecture
Explain dotnet framework ?
Explain how does .net mobile work? : Microsoft dot net mobile
Explain pipelining? : Dot net architecture
What is the .net class that allows the retrieval of a data element using a unique key?
Explain a .net mobile example with details? : Microsoft dot net mobile
What size is a .net object?
What is the difference between absolute expiration and sliding-time expiration?
Explain hard disk? : Dot net architecture
What is the difference between metadata and menifest ?
What is the mesi? : .NET Architecture
how to set the startup position of the form?
Explain difference between inprocess vs out process session state? : .NET Architecture
How do I stop a thread?
