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

Explain the difference between 'between' & 'and' operators in sql

1002

What are stored procedures in mysql?

1019

What is the difference between microsoft sql and mysql?

963

Why do we need cursor in pl sql?

1136

What are the triggers associated with image items?

1042

What are all the different normalization?

1038

How many types of indexes are there in sql?

985

How does an execution block start and end in pl sql?

951

Is the primary key an index?

1026

Can we write dml inside a function in sql server?

952

State few characteristics of pl/sql?

971

Can we rollback truncate?

999

What is sharding in sql?

987

Why is sql*loader direct path so fast?

1104

How do I quit sql?

963