how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?
Answers were Sorted based on User's Feedback
Answer / prasoon madnawat
SQL Server:
Select MIN(Salery) from (SELECT TOP 2 * from EMPLOYEE)
Oracle:
Select MIN(Salery) from (SELECT * from EMPLOYEE where ROWNUM <3)
MySQL
Select MIN(Salery) from (SELECT * from EMPLOYEE LIMIT 2)
| Is This Answer Correct ? | 0 Yes | 5 No |
Why the config file might not be writable
Explain how cache is used? : Dot net architecture
What is Ienumerable
How to upload in video,mp4,in .net 4.5 ..?
What is msil, and why should my developers need an appreciation of it if at all?
Can I create my own metadata attributes?
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
can u give me real example of how web.config overrides the machine.config file?
inprocess vs out process session state : Dot net architecture
does .NET support multiple inheritance ?
What is .net mobile utility controls. : Microsoft dot net mobile
Why should hire you in company