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 a primary key sql?

1014

does sql support programming? : Sql dba

1010

what are aggregate and scalar functions? : Sql dba

1008

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1180

What are pl/sql cursors?

1018

what is union? : Sql dba

984

Is grant a ddl statement?

867

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1086

explain commit and rollback in mysql : sql dba

968

What are the types of sql commands?

1050

Which constraints we can use while creating database in sql?

1039

which tcp/ip port does sql server run on? : Sql dba

985

What are the types of functions in sql?

983

What is before and after trigger?

914

What is pl sql quora?

1103