1. How to fetch all the duplicate records from the table.
2. How to fetch the second highest salary from the table.
Answer Posted / neelu
select max(salary) from employees where rownum<= 2
order by salary desc
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Mention the differences between sql server and mysql.
What do mean by xml datatype?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
How to stop log file growing too big?
What is sql server query analyzer?
Can we insert data if clustered index is disabled?
What action plan is preferred if sql server is not responding?
Write a query for primary key constraint with identity key word?
State the difference between union and union all?
Other than truncate statement, which other command can by-pass the trigger on the tables?
Explain syntax for disabling triggers?
What is the maximum size of sql server database?
What is the importance of a recovery model?
What are the steps you should follow to start sql server in single-user mode?
What is key attribute?