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 difference between after and before?

1073

Create and insert into temp table in sql server?

1018

Explain forward - only cursors?

1049

What is 2nf normalization?

1013

What is cached report?

143

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1137

What is auditing in sql server?

918

How many joins in sql server?

938

What is a not null constraint?

1018

How to convert a table data in XML format in sql server?

2532

What are the rendering extensions of ssrs?

157

Tell me the phases a transaction has to undergo?

956

What is the use of partition by in sql server?

927

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

137

How sql server enhances scalability of the database system?

1207