Interested to Buy Any Domain ? << Click Here >> for more details...
how to find nth highest salary
- 103 Answers
- 184657 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / venuprasadh
SELECT MIN(SALARY) AS Salary FROM user WHERE SALARY IN
(SELECT DISTINCT TOP 3 SALARY FROM user ORDER BY SALARY DESC);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are click through reports?
What is Federation and Federation Member?
What is transaction server explicit transaction?
What is a raid and what are different types of raid configurations?
What is partitioned view?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
What is self contained multi valued query?
what is the different types of backups available in sql server? : Sql server database administration
What is use of dbcc commands?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Do you know what is a linked server in sql server?
What are the acid properties?
Define msdb database?
How to insert new line characters into strings?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
