select*from(select rownum rn,sal from(select*from emp order by sal desc))wh

Find out the 3rd highest salary?

Question Posted / kumar

Answer Posted / kumar

select*from(select rownum rn,sal from(select*from emp order by sal desc))where rn=3

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is constant in pl sql?

1029

Can we group by two columns in sql?

1001

What do you mean by field in sql?

1087

How many developers work on postgresql?

987

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1441

How to rename a table?

1030

Can we create table inside stored procedure?

961

What is a full join sql?

1061

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1241

Can we create table in function?

968

What is out parameter used for eventhough return statement can also be used in pl/sql?

1085

What is data modelling in sql?

1025

explain mysql aggregate functions. : Sql dba

996

When to use inner join and left join?

963

How does one load ebcdic data? : aql loader

1178