Answer / san

It's not at all possible to create duplicate columns in a
SQL table. The how can we delete the duplicate columns?

Answer / sathyasheelanbe

delete from tablename where rowid not in(select max(rowid)
from tablename group by primary key columnname)

Answer / subash

In this query the values will delete based on employee names

delete from emp a1 where rowid<(select max(rowid)from emp a2
where a1.ename = a2.ename group by a2.ename having count(1) >1);

why we use aggregation in lower level

1 Answers   TCS,

---

what are the differences between web intelligence reports and crystal reports ?

3 Answers   AG Technologies,

---

i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?

5 Answers   TCS,

---

draw the architecture of bo

0 Answers   IBM,

---

Can anybody tell me about issues faced while creating universe. thanks in advance

1 Answers   Accenture,

---

normally we get many contexts when resolving loops or traps,how do u take them to reports.

2 Answers   Wipro,

---

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

3 Answers   iFlex,

---

What are the Errors in BO Pls Explain with Examples

2 Answers   iFlex, Tech Mahindra,

---

can i link two Universes having with different connection

3 Answers  

---

How to Analyise 'Join' problem and which method is the best to resolve that ?

3 Answers  

---

1.what is the difference between development,maintainace and support in bo? 2.what is dynamic date prompt?Is it feasible to create dynamic date prompt in universe?what is the procedure? 3.how can u say that a report is complex ,simple or medium? 4.yesterday i had run the report it took max 30 sec to run the report.but today i came and refresh the same report ,more than two hours completed,still result not came?where is the issue might be?note that at universe and report level no issues?where u will go fro 3rd verification?

1 Answers   Accenture,

---

What is the difference between sub-query & co-related sub query?answer ASAP....... thanks in advance..............Prakash

3 Answers   iFlex, Maintec, TCS,

---