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

Answers were Sorted based on User's Feedback



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

Answer / lakshmi reddy

top 10 records
select * from emp where rownum<=10

Based on maximum salary(hithest top 10 salaries with details)
select * from (select emp.* from emp order by sal desc)
where rownum<=10

Is This Answer Correct ?    0 Yes 0 No

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

Answer / harish

based on salary top 10 records for emp table

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

What is the information present in the cognos configuration file?

0 Answers  


If there are two values at value prompt level and when selecting first value it have to go to date prompt and when selecting second value we have to get output without any prompting. How to solve this issue. if any plz mail me on this vasuattada@yahoo.co.in

2 Answers   HCL,


how to hide a particular pages at time if you get blank pages

3 Answers   IBM,


dumps needed ASAP for - C2020-180 Cognos IBM Certification

0 Answers   Aptech,


hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

0 Answers  






can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

0 Answers  


What are the different types of reports present in cognos?

0 Answers  


How to Improve the Performance of the Report? i need this urgently .

4 Answers   HSBC,


what is view? types of views?

3 Answers   HCL,


suppose if u burst the reports if ur reports not reached to the destination how u will identify that one???

3 Answers   CTS, iFlex,


what are typees of dimensions

11 Answers   HCL,


Tell me about Dnamic and Static Dashboards?

0 Answers  


Categories