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 slowly changing dimensions? Why we are used scd?

0 Answers   IBM,

---

What are all types of prompt?

1 Answers  

---

What are Governer Settings?

2 Answers  

---

How can we change any header or footer for a group of reports

1 Answers   Satyam, Tech Mahindra,

---

What is Lookup ,bridgeing tables where they will use in the Dataware house

2 Answers   IBM,

---

---

what is surrogate key give example?

2 Answers  

---

Can we install cognos on windows 7?

4 Answers  

---

How many fact tables you have in your project?

1 Answers   HCL,

---

Why do we create shortcuts in framework manager

4 Answers  

---

APPLYING COLORS TO ALTERNATE ROWS IN A LIST REPORT

5 Answers   Satyam,

---

how to create average on totals of different departments employees salary...? consider we have 3 dept and in each dept 10-15 workers i need to get the totals separately for each dept and average of there totals..help me pls

2 Answers   Patni,

---

suppose a value prompt contains 100 values and i want to select all values in that prompt....i want ALL option in the value prompt? how can u keep this option in value prompt?

5 Answers   TCS,

---