select ename,salary from (select rownum,ename,salary from emp order by d

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

Question Posted / senorita

Answer Posted / senorita

select ename,salary from (select rownum,ename,salary from
emp
order by desc) where rownum=2;

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is update query?

922

What is sqlca in powerbuilder?

957

How can you load microsoft excel data into oracle? : aql loader

1130

Explain ttitle and btitle.

1058

How do I run a pl sql procedure in sql developer?

916

what are null values? : Sql dba

902

How can we make an if statement within a select statement?

959

explain access control lists. : Sql dba

949

How do I remove duplicates in two columns?

977

Is pl sql useful?

934

What pl/sql package consists of?

1033

What are the most important ddl statements in sql?

1027

What is an emotional trigger?

932

How do you delete data from a table?

976

What is the advantage of nosql?

996