how to find nth highest salary
Answer Posted / shiva
SELECT MAX( salary) FROM salary where salary not in(
SELECT DISTINCT TOP 3 salary FROM salary order by salary desc)
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
explain extended properties
Explain how many types of relationship?
Explain transaction isolation levels in sql server?
Difference between Inner vs outer joins?
What is database black box testing?
How can you insert null values in a column while inserting the data?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What is the Disadvantage of indexed sequential file.
How do I shrink an ldf file?
How to create nested stored procedure?
Can we write trigger for view?
What is the difference between Normalization and De-normalization?
Explain about system database?
Create and insert into temp table in sql server?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?