write a query for the fifth highest salary?

Answer Posted / shahid

select *from(select sal,rank() over(order by sal desc)as sal_rank from emp) where sal_rank=5;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of firebase?

546


Explain inner and outer joins with examples.

710


What is the best database software for small businesses?

501


Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it

1692


What is replicaset?

587






What are different types of joins used in?

622


Which is the best graph database?

533


How many indexes can be created on a table?

615


Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

1808


List the properties of a transaction.

637


What are the concurrency problems a database faces?

558


diff b/w inter process and in process

1554


What is dialect in database?

551


Differentiate between unique key and foreign key?

581


What do you mean by cluster and non cluster index?

569