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
- 20182 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / kunal gupta
These are the easiest and best queries and 100% tested.
1) 2nd highest salary
select top 1 sal from (Select top 2 sal from emp group by
sal order by sal desc) e order by sal
like wise you can find n highet salar(e.g 5th largest 6th
largest)
select top 1 sal from (Select top [n] sal from emp group by
sal order by sal desc) e order by sal
2) fetch all duplicated records from the table
e.g If table has three columns named 'col1', 'col2'
and 'col3'
select col1, col2, col3 from tbl group by col1, col2, col
having count(col1)>1
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
What are constraints in microsoft sql server?
how many clustered indexes can be created on a table? : Sql server database administration
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
what is a join and explain different types of joins? : Sql server database administration
What is the difference between having clause and where clause in sql server?
What is a cursor, index in sql?
Explain sql delete command?
‘Order by’ is not allowed in a view how can you sort information from a view?
Which is faster statement or preparedstatement?
what is difference between NULL and ISNULL in SQL Server 2008?
what is isolation level at dead lock?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
Does partitioning help performance?
What is indexing in sql server with example?
What is the difference between Clustered and Non-Clustered Index?
