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

How much does it cost to build a database?

573

What is the difference between data source and database?

550

What is ole db in ssis?

616

issues involved in modeling and building data werahouses

1560

What does currency type mean in database?

722

what are wrappers and build ups and what it's use?

1703

How to produce such kind of file?

635

What are the advantages of views in a database?

646

Can you tell any two advantages of stored procedures?

598

How to do Stored procedure testing? Who does this testing (Developer or tester)?

1389

Explain about ur projets on teradata???

1364

After normalization, what are the conditions which have to keep in mind to de-normalize it?

624

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

1741

What is replicaset?

594

What is a database example?

540