how to find nth highest salary
- 103 Answers
- 163925 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / avinash
declare @n;
set @n = N
select * from tbl
where @n in (
select dense_rank over (order by salary) as rank_sal
from tbl )
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to download and install microsoft sql server management studio express?
What are the drawbacks of reporting in ssrs?
What is bookmark link in ssrs?
Does group by or order by come first?
What is the synonym of join?
Differentiate between a having clause and a where clause.
What is the meaning of resultset type_scroll_insensitive?
How can you list all the columns in a database?
What is data source document?
If a stored procedure is taking a table data type, how it looks?
What are different types of schemas?
What is the use of custom fields in report?
What are the disadvantages of using querystrings to send data from one page to another?
what is the difference between a primary key and a unique key? : Sql server database administration
What is repeatable read?
