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 a fill factor?

1069

What is sql collation?

1180

How to modify an existing user defined function?

1081

What is serializable?

1026

Can sub report data source be different from that of the parent report?

141

What is temporary stored procedure?

920

Can sql server be linked with other servers like oracle?

944

What is difference between materialized view and view?

896

Do you know what is fill factor and pad index?

986

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

964

What are the benefits of normalization?

1084

How to create a user to access a database in ms sql server using "create user" statements?

937

How do you drop an index?

902

What is report server project?

145

Can a unique index be created on a column, which contains null?

903