select max(salary) from Emp where rownum

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

Question Posted / jeff

Answer Posted / jeff

select max(salary)
from Emp
where rownum < 2;

Is This Answer Correct ?

3 Yes

19 No

Please Help Members By Posting Answers For Below Questions

What are sql procedures?

962

what does myisamchk do? : Sql dba

961

What is a call statement? Explain with an example.

949

How to sort the rows in sql.

1005

What is structural independence and why is it important?

978

Can you join views in sql?

896

What are the different types of functions in sql?

995

What does (+) mean in sql joins?

1007

Why we use sql profiler?

908

How many scalar data types are supported in pl/sql?

974

What is sql engine in oracle?

925

What is execution plan in sql?

978

What is dml and ddl?

897

What are two statement types in sql?

1029

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1081