select max(salary) from employees where rownum<= 2 order by salary desc

1. How to fetch all the duplicate records from the table.

2. How to fetch the second highest salary from the table.

Question Posted / neelu

Answer Posted / neelu

select max(salary) from employees where rownum<= 2
order by salary desc

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain indexed views and partitioned view with their syntax.

1195

What is BLOCK statements in SQL?

1312

How to execute a sql statement using odbc_exec()?

1220

What is the syntax to execute the sys.dm_db_missing_index_details?

1077

What is difference between index and primary key?

1142

What happens when the SQL Azure database reaches Max Size?

113

Where the sql logs gets stored? : sql server database administration

1014

How many categories of functions based their return modes?

1152

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2550

Write an sql query for deleting duplicate rows?

1038

How to return the top 5 rows from a select query in ms sql server?

1209

What is simple indexing method?

1083

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1124

Explain sub-query?

1014

Tell me what are the essential components of sql server service broker?

991