write a query for the fifth highest salary?

Answer Posted / sujit

Hop it helps!

Select sal from (select sal from emp order by sal desc
where rownum<6);

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the table term used in database.

590


how can you perform lookup range in lookup stage expalin in detail?

1533


What is a trace file?

647


Differentiate between delete and truncate table?

639


What is database client?

555






What is the function of cluster index?

622


Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.

933


What is the difference between specialization and generalization?

589


Data structure used to implements a menu:

640


What is database collection?

590


What is a database connection string?

595


What do you mean by foreign key and primary key?

633


What is dialect in database?

566


Differentiate between extension & intension?

883


How default key is different from primary key?

627