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 are the limitations of cognos reportnet? What are the enhancements in reportnet ?

1135

What are the steps to import the two data sources in framework manager?

1092

what are the features in cognos8ui

2100

What are all the types of hierarchies?

1176

How we check the errors before running the report?

1039

All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

2143

WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

6975

What is a dimension?

1077

what is the role of cognos comsultant?what actually it means?pls reply

2370

can you tell me what are the dimension tables are used in project

2354

What are the main services provided by application tier?

1026

How create measures and dimensions?

1132

Can you define drill across?

1031

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

11849

explain how to create powerplay reports?

1066