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

How many categories of functions based their return modes?

1097

What are the new scripting capabilities of ssms? : sql server management studio

1055

If user is owning any SQL Objects, can we drop that user

2060

How do you troubleshoot errors in a SQL Server Agent Job?

1049

Why I am getting this error when dropping a database in ms sql server?

1070

Difference between Logical Page and Physical Page in SSRS.

474

When we should use @@error?

958

Explain about SQL server 2005?

965

Why is normalisation important?

936

How do you manipulate data?

897

Is sql server is free?

970

Can you please explain the difference between function and stored procedure?

1000

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1202

what are different types of raid configurations? : Sql server database administration

1048

Tell me what do we need queues in sql service broker?

981