Answer Posted / madhoo

You are question is not clear.....you need decide based on
which column you want first 10 records.....

if you work on Salary column this is the query .......

select distinct sal from emp a
where (select count(*) from emp b where a.sal<b.sal)<=10
order by sal desc
/

Any queries on Sql please feel free to ask me i am very
interest in it......

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

1947

---

What is the difference between drill through, drill across?

1033

---

What are the other methods working as deployment functionality?

908

---

Define query items?

971

---

plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........

2317

---

Explain informatica architecture?

940

---

what is requery in cognos?

2459

---

What are cognos connection initial page components?

1074

---

What is the enterprise class platform architecture of cognos 8?

987

---

How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..

1889

---

Can you define slice?

985

---

Can you define report item?

996

---

Is it possible to join multiple Databases in a Catalog?

1079

---

Can you define query studio?

925

---

How do we convert from Numeric to be Words?

2960

---