select Salary from ( select salary from emp order by desc) as employee wher

write a query for the fifth highest salary?

Question Posted / chethan

Answer Posted / chethan

select Salary from ( select salary from emp order by desc) as employee where rownum = 5;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the record term used in database.

666

Explain entity ?

602

What are different types of blocks used in stored procedure?

631

On startup, the transaction log of a database has filled and recovery has suspended, what can I do?

554

What is ole db in ssis?

614

can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?

1670

What is the best database?

527

List the properties of a transaction.

637

Is redis in memory database?

543

Is hive a database?

558

What is the role of driver manager?

589

Explain alternate key?

651

Explain partial key?

656

What is sharded database?

510

What is redis good for?

557