select rank,sal from(select rownum rank,distinct(sal) from emp order by s

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

Question Posted / dilip

Answer Posted / dilip

select rank,sal from(select rownum rank,distinct(sal) from
emp order by sal desc)
where rank=2;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to disable a trigger name update_salary?

1251

Explain the significance of the & and && operators in pl sql.

989

What are the different parts of a package?

1100

What is the use of <> sql?

960

what are the different tables present in mysql? : Sql dba

958

What are inner and outer joins examples of both?

940

Why we use join in sql?

944

What is normalization sql?

1039

Explain locks? : Transact sql

987

Can we perform dml on view?

1029

how to use myisamchk to check or repair myisam tables? : Sql dba

957

What is the difference between inner join and natural join?

990

Which normal form is best?

937

what is cross join? : Sql dba

980

What is the plv (pl/vision) package offers?

1029