1. How to fetch all the duplicate records from the table.
2. How to fetch the second highest salary from the table.
Answer Posted / anbarasan k kanagaraj
select salary from user order by salary desc LIMIT 1, 1
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the difference between dropping a database and taking a database offline?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What part does database design plays a role in performance of an sql server-based application?
Explain encryption of entire databases without the need for application changes in sql server 2008?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What are the types of subquery?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
What is bookmark link in ssrs?
What are the purposes and advantages stored procedure?
What will be the maximum number of indexes per table?
What are sql server procedures?
Name few of the dcl commands in sql?
List out a number of the wants to setup a SQL Server failover cluster?
What is logshipping and its purpose?
What are page splits?