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 is report snapshot in ssrs?

280

What are the five major components of a dbms?

961

What are the different methods available under sqlcommand class to access the data?

1169

What are types of storage modes? : sql server analysis services, ssas

1084

What is a virtual table in sql?

1037

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

962

What Are the Main Features of SQL Azure?

121

How to read data in a table with "select" statements?

1028

What is a with(nolock)?

1026

What does COMMIT command do?

1122

What is catalog views?

1121

Why should one not prefix user stored procedures with ‘sp_’?

1099

How to retrieve field values using mssql_result()?

1418

Why use sub query in sql server and list out types of sub queries?

1056

What is the full meaning of dml?

999