Find out the 3rd highest salary?
Answer Posted / karna
Hi Friends,
to get the nth highest value of a column in a table,please
use the below simple query
select min(column) from table where column in(select top n
column from table)
any queries,mail me at karun84@gmail.com
Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
How do I trace sql profiler?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is the difference between local and global temporary table?
What is hibernate and its relation to sql?
What is the best free sql database?
What are different types of keys?
What is pivot table in sql?
Why do we use cursors?
How to find 3rd highest salary of an employee from the employee table in sql?
How do you truncate?
How many types of sql are there?
Explain mutating table error.
How to start oracle sql developer?
What is the use of & in pl sql?
What are the different sql commands?