Interested to Buy Any Domain ? << Click Here >> for more details...
how to find nth highest salary
- 103 Answers
- 182125 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / affu
select salary from table t where n-1=(select distinct count
(sal) from table t1 where t1.sal>t.sal)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the difference between “where” and “having” clause in sql server?
How do you create a data source?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
List the advantages of using stored procedures?
What do you understand by a view? What does the with check option clause for a view do?
What are the various editions of sql server 2017 that are available in the market?
explain different types of constraints? : Sql server database administration
Why do we partition data?
How to find tables without indexes?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What happens if you delete a table that is used by a view?
How to achieve Paging of records in SQL SERVER?
What is bit data type?
Does partitioning ssd reduce performance?
Explain what is lock escalation and what is its purpose?
