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;

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?

14 Answers   HCL,

---

What are the types of security?

0 Answers  

---

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

0 Answers   EDS,

---

what is Associated grouping? and how it works in cognos impromptu?

1 Answers   IBM,

---

Hi All, When user run the cognos report, that report output data must be download/available in EXCEL / CSV file.? (like... list report contain PL,PT,PN,RVEN, that excel/csv default download must be list columns PL,PT,PN,REVN) Thanks in Advance, LN.

2 Answers   IBM,

---

Can any one give the example for slicing and dicing of data ?(with simple query)

3 Answers   Cognos,

---

Can i apply drill through on chart in report studio?

4 Answers   TCS,

---

What is the enterprise class platform architecture of cognos 8?

0 Answers  

---

im having null data in one of the cell in my report i have to display as "no data" when u run the report how can i achive this problem?

6 Answers   IBM,

---

what is fact less fact give me proper example?

2 Answers  

---

what are ERP systems?

1 Answers  

---

How can you schedule a report based on different time zone ?(ex: local time should be same as 10 am . Japan should get the report at 10 am. USA should get the report at 10 am).Is that possible?

1 Answers   HCL, iGate,

---