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

Does a server store data?

903

What are the benefits of normalization?

1086

Can You Use Data Mining Models In Ssrs?

145

What are the disadvantages of indexes?

1067

Is there any difference between the primary key and unique key?

988

Explain timestamp datatype?

947

How will you add a dimension to cube? : sql server analysis services, ssas

1059

How do I start sql server 2017?

919

What is resource governor?

953

What do you mean by an execution plan?

1092

What does REVERT do in SQL Server 2005?

943

Explain cross join or cartesian product in sql?

875

What do you understand by coalesce in sql server?

1042

What happens when the SQL Azure database reaches Max Size?

111

Explain the dirty pages?

982