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 are the advantages of normalizing a database.

1073

Under which circumstance should you create an index on a table?

1181

What is a super key?

1050

Explain the various types of normalization.

1091

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

1127

what is the role of auditor in auditing data oriented applications?

2402

What is Object Oriented model?

1044

What is the Lock Based Protocol used for?

1092

how can we view column head in first page but not in remaining pages?

2051

What is a Transformation?

1038

Which three commands cause a transaction to end?

1079

Which database is best to store images?

1058

What is odm in database?

1102

What is Data Modelling?

1090

Should I store images in database?

1048