Answer / krishna

To display the 3rd record of emp table we can write query as
select * from emp where rownum<4 minus select * from emp
where rownum<3;

Answer / srinu

select * from(select rownum r,emp.* from emp) where r=3;

Answer / kumar

select * from emp where rownum<4 minus select * from emp
where rownum<3;

Answer / g.arangarasu

No friends,

rownum is one of the column name of table like
emp_no,emp_name etc. if u have not rownum column in ur
table,how to solve it.

we can retrieve this record through physical location that
is using rowid not rownum.

select min(rowid) from emp not in(select min(rowid) from
emp not in(select min(rowid) from emp));

What is meant by grouped star schema

0 Answers   IBM,

---

What is power prompts?Can somebody explain me.

2 Answers  

---

How do you deployment reports from one server (Development) to other server(Production)? How do you configure the cognos7.0 version cube in cognos 8.0? Pls, explain with example? How do you create IQD without IMR or can u explain other way create IQD?

2 Answers   TCS,

---

In framework Manager, what is a stitch query and is it good or bad?

2 Answers   Polaris,

---

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.

0 Answers   CTS,

---

what is the difference between java script and html in cognos?

1 Answers   IBM,

---

What is content Manager?

3 Answers   HCL, Kekran Mekran,

---

What is the information present in the cognos configuration file?

0 Answers  

---

how you create security to reports?

0 Answers   IBM,

---

What is cognos reporting tool?

0 Answers  

---

What is difference between page break and section report? What is main advantage datawarehousing over oracle?

0 Answers  

---

-------------What is a Conformed Dimension?

3 Answers   Bank Of America,

---