Interested to Buy Any Domain ? << Click Here >> for more details...
how to find nth highest salary
- 103 Answers
- 184677 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / dinesh
select distinct(a.salary)
from Salarydtls a
where 3= (select distinct(count(b.salary))
from salarydtls b
where a.salary<=b.salary)
ans is for third highest sal
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
what happens on checkpoint? : Sql server database administration
Why use identity in sql server?
How to delete a login name in ms sql server?
What is temporal table?
What is a field in a table?
What is query processing?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Is INSTEAD OF trigger directly applicable to Table ?
What is the name of reporting services config file and what’s it’s used for?
How to modify an existing user defined function?
Explain concepts of analysis services?
What does Master database contains?
Do you know what are acid properties of transaction?
What is the default schema of your login session in ms sql server?
What is bcnf normalization form?
