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
Explain indexed views and partitioned view with their syntax.
What is BLOCK statements in SQL?
How to execute a sql statement using odbc_exec()?
What is the syntax to execute the sys.dm_db_missing_index_details?
What is difference between index and primary key?
What happens when the SQL Azure database reaches Max Size?
Where the sql logs gets stored? : sql server database administration
How many categories of functions based their return modes?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
Write an sql query for deleting duplicate rows?
How to return the top 5 rows from a select query in ms sql server?
What is simple indexing method?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
Explain sub-query?
Tell me what are the essential components of sql server service broker?