select * from ( select * from employee order by salary desc) where ro

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

Question Posted / phoebe

8 Answers
12717 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / phoebe

select * from
(
select * from employee
order by salary desc)
where rownum<11;

Is This Answer Correct ?

4 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the types of catalogs in cognos?

1109

what are the errors faced while bursting the reports and how to solve those errors?

1976

1. Explain your project.

1996

What is the advantage of using shortcuts?

1127

dumps needed ASAP for - C2020-180 Cognos IBM Certification

2172

How is possible this scenario using in type-in prompt.?

1009

What are the different types of important services used in cognos?

985

what is stitch query in reportnet?

1056

7. What is performance tuning?

1959

what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

2263

can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

2000

What is the difference between static and dynamic conditions?

1038

What are the types of folder present in cognos?

1067

In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1944

How the Bursting happens in same report and how to Print the bursting Report?

1828