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
What is the purpose of firebase?
Explain inner and outer joins with examples.
What is the best database software for small businesses?
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
What is replicaset?
What are different types of joins used in?
Which is the best graph database?
How many indexes can be created on a table?
Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:
List the properties of a transaction.
What are the concurrency problems a database faces?
diff b/w inter process and in process
What is dialect in database?
Differentiate between unique key and foreign key?
What do you mean by cluster and non cluster index?