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

Explain polymorphism in pl/sql.

1096

Why do we use cursors?

976

Explain what is table in a database?

1046

What does partition by mean in sql?

947

Describe different types of general function used in sql?

1016

How exception is different from error?

1003

What is a file delimiter?

1070

What mean sql?

992

How does sql*loader handles newline characters in a record? : aql loader

1026

What are the advantages of stored procedure?

989

Is there a 64 bit version of ssms?

945

Which is better join or inner query?

1019

How do I get sql certification?

954

What does where 1 1 mean in sql?

1019

what is the bond code in materialized view?

2984