Interested to Buy Any Domain ? << Click Here >> for more details...
1. How to fetch all the duplicate records from the table.
2. How to fetch the second highest salary from the table.
- 12 Answers
- 20657 Views
- Accenture, I also Faced
- E-Mail Answers
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 command dbcc checkdb used for?
what is a check constraint?
What is a recursive stored procedure in sql server?
What are the properties of the transactions?
What are the purposes of floor and sign functions?
What are the properties and different types of sub-queries?
What is the use of keyword with encryption. Create a store procedure with encryption?
What are the new features of sql server 2008 r2 reporting service?
What happens if null values are involved in comparison operations?
What are orphan records?
What are trace files?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
What is a collation?
How do you delete a trigger?
How to add additional conditions in SQL?
