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 the basic structure of an sql?

1080

What is primary key sql?

1017

Can we use views in stored procedure?

1020

Explain table and field in sql?

1051

How subquery works in sql?

1054

How do I make sql search faster?

982

What is the difference between join and natural join?

919

how to fetch alternate records from a table? : Sql dba

1088

How many types of relationship are there?

1021

What will you get by the cursor attribute sql%rowcount?

1020

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

960

How many sectors are in a partition?

1064

What does an inner join do?

1164

What are different types of triggers?

1086

How many types of literals are available in pl sql?

1101