Use the below Query: Select Max(salary) from Emp Where Max(salary) <

Write a query to find second highest salary of an employee.

Question Posted / amol londhe

Answer Posted / amol londhe

Use the below Query:

Select Max(salary) from Emp
Where Max(salary) < (Select Max(salary) from emp
where emp-no=101);

Is This Answer Correct ?

10 Yes

18 No

Please Help Members By Posting Answers For Below Questions

What are local and global variables and their differences?

823

Which kind of parameters cannot have a default value in pl sql?

815

What do you mean by field in sql?

806

What does bitemporal mean?

775

What is a nested table in word?

716

What are pl sql procedures?

715

what are the drivers in mysql? : Sql dba

746

How are sql commands classified?

813

What is pl sql script?

739

How to display Row Number with Records in Oracle SQL Plus?

777

What is the use of index in sql?

778

What is primary key and foreign key?

733

How to order siblings in oracle hierarchy queries?

780

How to connect a sql*plus session to an oracle server?

838

Can unique keys be null?

673