write query for fourth maximum salary from employee table
Answer Posted / arun kumar
select top 1 e.emp_code,e.emp_name,ed.basic_salary from
employee_master e, employee_salary_detail ed where
e.emp_id=ed.emp_id order by basic_salary desc
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is sql server agent and what are the two modes of authentication in sql server?
What are the disadvantages of using the stored procedures?
what are the disadvantages of cursors? : Sql server database administration
What is open database communication (odbc)?
What is a transaction and why is it important?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
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 implicit cursors?
How many types of built in functions are there in sql server 2012?
What is the impact on other user sessions when creating indexes?
Can binary strings be used in arithmetical operations?
What are the purposes of floor and sign functions?
How to get the definition of a trigger back?
What do you know about system database? : SQL Server Architecture
Which joins are sql server default?