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

Is pl sql different from sql?

1006

What are the most important ddl statements in sql?

1120

What are the types of records?

993

How many sql statements are used? Define them.

1045

Define commit, rollback and savepoint?

1036

Can you load data into multiple tables at once? : aql loader

1075

What is record data type?

920

what is a foreign key ? : Sql dba

1087

How do I make my sql query run faster?

948

what is a cursor? : Sql dba

1030

How many types of privileges are available in sql?

1351

explain about mysql and its features. : Sql dba

1021

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1077

How do I start sql profiler?

1001

Explain isolation levels. : Transact sql

1075