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

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

2852

What is ole db used for?

588

Explain entity set?

594

What the various ways to tune a teradata query

2799

WHAT KIND OF TOOL BO IS?

1851

Is it good to store images in database?

560

What is the Difference Primary key and Unique Key

590

What is the role of driver manager?

599

How to produce such kind of file?

642

How many indexes can be created on a table?

625

What is dialect in database?

565

WHAT IS CARDINALITIES OF JOIN?

1939

Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

710

5. Explain about relational algebra.

1739

aht is the difference b/w network & hierarchial & relational dbms????

1783