Interested to Buy Any Domain ? << Click Here >> for more details...
how to find nth highest salary
- 103 Answers
- 179686 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 encryption security is available in sql azure?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
What are the High-Availability solutions in SQL Server and differentiate them briefly?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What are the advantages of sql azure?
What language is sql server written in?
What is tcl in sql server?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What are acid properties of transaction?
Is sql server is free?
How to use subqueries in the from clause in ms sql server?
why would you call update statistics? : Sql server database administration
What are pessimistic lock and optimistic lock?
Do you know what is rank function?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
