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

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

Question Posted / vamana murthy

Answer Posted / vamana murthy

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

Is This Answer Correct ?

0 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Why do we use sql constraints?

1123

What does pl sql developer do?

882

What is difference between my sql and sql?

996

What are the different sql languages?

985

Explain spool.

1111

How many disk partitions should I have?

941

Explain isolation levels. : Transact sql

1015

explain the difference between myisam static and myisam dynamic. : Sql dba

885

What is interval partition?

986

Is natural join and inner join same?

853

How do you get column names only for a table (sql server)?

1100

What does sql stand for?

944

What does data normalization mean?

897

Can there be more than one function with a similar name in a pl/sql block?

925

how to enter numeric values as hex numbers? : Sql dba

1006