select max(salary) from emp where salary<(select max(salary) from emp)

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

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

Question Posted / oracle.hemant

Answer Posted / oracle.hemant

select max(salary) from emp where salary<(select max(salary)
from emp)

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What do you understand by the denormalisation?

959

What happens when transaction log is full?

928

New concepts of sql server 2005 use in your project.

2362

How to insert multiple rows with a subquery?

1135

What does it mean to normalize data?

943

Define self join?

1032

What are the different types of collation sensitivity in sql server?

1113

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

941

What is sub-query in sql server? Explain its properties.

1093

What is dbcc command in sql server?

1093

What the different topologies in which replication can be configured?

1092

What are different type of Collation Sensitivity?

1003

What are the different types of locks in the database?

925

How to transfer a table from one schema to another?

1003

How many types of objects are there?

1009