select *from(select sal,rank() over(order by sal desc)as sal

write a query for the fifth highest salary?

Question Posted / shahid

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

Please Help Members By Posting Answers For Below Questions

What is the difference between specialization and generalization?

1032

How do you connect to a database?

1111

What is redis good for?

958

Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.

2554

can we delete autodiff back up that we have set through sql server agent.

2203

Explain the record term used in database.

1084

Is storing images in a database a good idea?

1000

What is ole db used for?

1015

Why do we need distributed database?

1003

define primary key index, bitmap index, hash index,virtual indwx

3319

How do you pass parameter in stored procedure?

1211

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

2242

Differentiate between unique key and foreign key?

1015

Write a query to retrieve for many to many relationships?

1011

Explain transaction manager?

1087