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
Can another user execute your local temporary stored procedures?
Is it possible to call a stored procedure within a stored procedure?
What is database mirroring?
What is normalization? What number of normalization shapes are there?
What is join and name different type of joins?
Do I need a report server to run reports in my application?
What is the difference between clustered and a non-clustered index?
Where the sql logs gets stored?
What new data source types were added in ssrs 2014?
Write a SQL query to delete a table?
How to insert data with null values?
What are the different types of collation sensitivity in sql server?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
Explain cursor as data base object?
What is catalog views?