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......

What is a Query Subject?

1095

---

What is a Framework manager?

1050

---

What is the report studio?

1019

---

Explain the difference between native sql and cognos sql?

1023

---

Diff b/w Crossproduct and Outerjoin?

2288

---

What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

1166

---

---------------Tell me about DWH Concepts?

2151

---

How Metrics Studio is better than Report Studio?

2605

---

What is set to be Cognos configuration?

1029

---

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

2246

---

What are all the different types of prompt in cognos?

1051

---

How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

3305

---

Can you define cognos impromptu?

1035

---

what is log in cognos?

1202

---

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 ?

2002

---