select * from ( select e.*,dense_rank() over(order by sal desc) rank fr

write a query to display to 10 max record from the employee
table?

Question Posted / ram

Answer Posted / ram

select * from
(
select e.*,dense_rank() over(order by sal desc) rank from emp e
)
where rank<=&rank

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is Bitmap Index?

980

What is a Pivot?

1041

how u burst the reports? if u r bursted reports is not reached to destination how u identify???

11605

Give me any example of semi and non additive measures?

896

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2325

Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

1993

Can you define cognos powerplay?

1031

Define dimensions?

968

Tell me about Dnamic and Static Dashboards?

2270

Can you define a catalog and types of catalogs in cognos?

997

It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

2357

Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?

1026

What is the difference between static and dynamic conditions?

1015

Which studio is used to create reports?

1055

Can you explain the advantage of using shortcuts?

983