Interested to Buy Any Domain ? << Click Here >> for more details...
how to find nth highest salary
- 103 Answers
- 184696 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / sudhir
DISPLAY THE RECORDS WHO'S GETTING 3RD HIGHEST SALARY.
SELECT * FROM EMP E1
WHERE 3 =(SELECT COUNT(DISTINCT(SAL))
FROM EMP E2
WHERE E1.SAL <= E2.SAL)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
What is difference between primary key and foreign key?
To which devices can a backup be created and where should these devices be located? : sql server management studio
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
Distinguish between commit and rollback?
what are constraints? Explain different types of constraints? : Sql server database administration
What happens when converting big values to integers?
List the advantages of using stored procedures?
What are distributed partitioned views?
How do I find my localdb version?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
What is difference between Datepart() and Datename() in SqlServer?
what is the difference between Delete and Truncate command in SQL
How can we delete Duplicate row in table?
What is page-level compression?
