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 query optimization process?

520

Write a program using SQL queries to find a unique entry in a table.

546

How do you improve the performance of a SQL Azure Database?

115

What are system databases in ms sql server?

539

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

106

What do you understand by the analysis services in sql server?

538

Can we call stored procedure in view in sql server?

500

What is a bit datatype?

562

What is a group function explain with an example?

523

What do you mean by acid?

578

How is SQL Azure different than SQL server?

What is the difference between dropping a database and taking a database offline?

698

What program is used to store the data source file?

503

How you can move data or databases between servers and databases in sql server?

568

How to transfer a table from one schema to another?

560