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 the use of Generated Prompt? Where is it used in realtime project?

3 Answers   HCL,

---

Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

0 Answers   IBM,

---

what is model and how to create model and how to test model?

8 Answers   IBM,

---

Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

0 Answers  

---

What is a business view? and what is the difference b/w business view and folder?in cognos report life cycle when it will be involved ?

1 Answers  

---

diff b/w grouping and aggregation

1 Answers   HCL,

---

How do we run stored procedure?

1 Answers  

---

What is the difference between the standard and metrics folder?

0 Answers  

---

explain how to create powerplay reports?

0 Answers   IBM,

---

Can you define pivot?

0 Answers  

---

What is TRAP in Framework manager?What's the use of TRAP? Where We are using this?

2 Answers   HCL, TCS,

---

i wanna some client names and project names in cognos? plz send cognos resumes(3+) exp plz plz plz help me??

1 Answers   TCS,

---