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
- 20555 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 page splits? : SQL Server Architecture
What is data file in computer?
Why should we go for stored procedures? Why not direct queries?
Explain the truncate command? : SQL Server Architecture
Explain having clause?
how can u get last observation in an unknown dataset ?
What are sql server procedures?
how would you troubleshoot blocking? : Sql server database administration
What is the current limitation of the size of SQL Azure DB?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
Explain the difference between functions and stored procedures in sql server?
How to assign new column names in a view?
What methods do you follow to protect from sql injection attack?
Can another user execute your local temporary stored procedures?
Explain the usage of floor function in sql server.
