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 not null in sql?

1057

What is varchar example?

1032

What is the use of count (*) in sql?

1054

What is the life of an sql statement?

1024

Can sql function call stored procedure?

1025

What is sql*loader?

1192

How do you go back in sql?

986

Explain the difference between sql and mysql.

1063

How do I partition in sql?

964

what are the 'mysql' command line arguments? : Sql dba

1139

What does select top 1 do in sql?

1098

Differentiate between pl/sql and sql?

1152

Why cross join is used?

1077

How many tables can a sql database have?

978

What does trigger mean in psychology?

962