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 the different type of sql's statements ? : Sql dba

926

Define union, minus, union all, intersect ?

1010

What is the least restrictive isolation level? : Transact sql

1070

What is the difference between python and sql?

1008

What are some emotional triggers?

986

What is record type in pl sql?

999

How do I create an index in word?

1035

What is sql profiling in oracle?

1066

What is the difference between in and between in sql?

1065

Explain autonomous transaction.

1161

What is the difference between nvl function, ifnull function, and isnull function?

1115

What is sql procedures and functions?

1012

Do ddl statements need commit?

974

Why we use triggers in mysql?

993

Is a secondary key the same as a foreign key?

1038