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

Answer / harish

based on salary top 10 records for emp table

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

What are the types of folder present in cognos?

0 Answers  

---

why u need to publish the package?

5 Answers   IBM,

---

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

7 Answers   HCL,

---

Once reports are delivered to client, how will they inform back? If they are experiencing any problem in the reports.

2 Answers  

---

What is conditional Formatting?

2 Answers   HCL,

---

What is difference between content store and content manager?

0 Answers  

---

--------------Explain Table of contents?

0 Answers   Cap Gemini,

---

What is meant by alternate drill down with ex?

0 Answers  

---

I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the tables we hava to create list columns like(country,month,net revenue)when i run the report if my retrevenue'0'this plasa i want to display'NULL'

2 Answers   Cap Gemini,

---

1. Differences between Merge and Union In Cognos?

0 Answers   Wipro,

---

-------------How you design DWH?

0 Answers   Bank Of America,

---

These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?

2 Answers   IBM,

---