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);

I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same

2 Answers  

---

Explain in detail about type 1?

0 Answers  

---

How to hide objects or columns?

6 Answers   Infotech,

---

i am getting multiple values from prompt like (Value1;Value2;Value3;Value4). how can i place space between values like (Value1; Value2; Value3; Value4)

0 Answers  

---

How to change English language to Chinese in BO Desiner (Universe)?

5 Answers   iGate,

---

What is top business?

0 Answers  

---

how to make a report avilable to other users?

2 Answers  

---

Can we take report on Excel in Business Objects?

6 Answers   Business Intelligence Analytics, Oracle,

---

how to find the size of the report

1 Answers  

---

Explain how many universes can be created in a project?

0 Answers  

---

how can we build one report from two data bases

4 Answers   IBM,

---

Can any body Explain me what are the critical problems you have faced in the designer and repoting level in the real time environment?

2 Answers  

---