select * from(select rownum r,emp.*from emp order by sal desc) where r<

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

Question Posted / srinu

7 Answers
13774 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / srinu

select * from(select rownum r,emp.*from emp order by sal
desc) where r<=10;

Is This Answer Correct ?

6 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How is cognos model organization works?

1018

what is model and say about process how to create model and how to test model?

1011

What do you understand by the term 'dynamic cube'?

946

Explain difference between powerplay transformer and power play reports?

918

What is the difference between Standard and Metrics folder?

1012

What is the difference between a data mart and a data warehouse?

1001

What do you mean by query studio?

897

how u will design the report if the objects are available

2711

Explain what is the difference between native sql and cognos sql?

950

How we check the errors before running the report?

950

What errors and types of errors you faced in Cognos ReportNet?

4116

What is the use of powerhouse?

999

actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....