how to find nth highest salary
Answer Posted / debasish
select salary from table t where n-1=(select distinct count
(sal) from table t1 where t1.sal>t.sal)
| Is This Answer Correct ? | 19 Yes | 11 No |
Post New Answer View All Answers
How to provide login information for a new odbc dsn?
How to use clusters?
What is the full meaning of dml?
How to find the list of fixed hard drive and free space on server?
Differentiate between a primary key and a unique key.
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
What is difference between equi join and inner join?
What is function of ROLLUP ?
What is the difference between stored procedure and functions?
What are the different type of replication in sql server?
List the various tools available for performance tuning?
What does it mean to normalize a database and why would you do it?
What is Dependency Injection and provide example?
Can you please explain the difference between primary keys and foreign keys?
Write query to return all rows sql?