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
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Can we write trigger for view?
How do I view a procedure in sql server?
Where is localdb stored?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
How to name query output columns in ms sql server?
Why do we need different type of parameter?
what are the important architecture components of SSRS?
What is sql server replication? : sql server replication
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
How to create a new table in a given schema?
what is the difference between openrowset and openquery?
What are the differences between decimal and float in ms sql server?
Differentiate between a local and a global temporary table?