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 is sql character function?

1097

How can you know that statistics should be updated?

1086

Why do we use cursors?

994

What is the use of index in hive?

1007

how do you know the version of your mysql server? : Sql dba

1010

What is sorting in sql?

956

Why do we need cursor in pl sql?

1142

What do you think about pl/sql?

1042

What does count (*) mean in sql?

1595

Difference between truncate, delete and drop commands?

1091

Can we rollback truncate?

1008

What is a constraint?

1030

Are subqueries faster than joins?

1027

Is sql free?

980

what are different types of collation sensitivity? : Sql dba

1079