Answer Posted / vsandhyana

Hi Hashmatulla Baig,

I think your query will not give the desired output. it
should be modify please refer below for the same.

SELECT empno, sal
FROM
(
select empno, sal, (ROW_number() OVER (order by sal desc)) R
from emp
order by sal desc
)
WHERE R = 5;

Can you define a query subject?

974

---

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

1970

---

How can I test reports in cagonos?

904

---

Define query studio?

945

---

What is a Datastore in Cognos?

1225

---

What are various types of gateways in cognos?

967

---

what is catalog and types of catalogs in cagnos and which is better?

1102

---

Can you define confirmed dimension?

1021

---

Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.

1320

---

What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

4521

---

What are the advantages of using cognos sql?

1124

---

what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

2003

---

Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

1997

---

What are query items?

971

---

What are the advantages of cognos?

917

---