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
- 13281 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 the types of memory management? : .NET Architecture
Why am I getting an invalidoperationexception when I serialize an arraylist?
Can you explain control extenders?
What is .net mobile images control. : Microsoft dot net mobile
What is a managed code is dim fs as filestreamobject is a managed code? : .NET Architecture
question related to table havi colspan and row span
Different types of authentication modes in .net framework ?
Define cache? : Dot net architecture
Explain domestic architecture artifacts? : .NET Architecture
what are the fundamental and common properties of .net controls?
What is difference between Desktop, Client Server & Web based applications?
Does .NET runtime offer Deterministic Destruction or not?
What is a clickonce application?
Explain about clr?
Explain pipelining? : Dot net architecture
