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

Can anyone tell me how to display (calculate )Turn Around Time between two dates in the BO Report? Thanks in Advance

1 Answers  

---

i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact tables in a report?

4 Answers   Cap Gemini,

---

How do you find what type of trap is there by seeing the report?

4 Answers   TCS,

---

Can we take report on Excel in Business Objects?

6 Answers   Business Intelligence Analytics, Oracle,

---

if we shortcut join between two tables what will be the output?that it will give all columns or same columns?

2 Answers  

---

---

Steps to create alias and apply

2 Answers  

---

how to connect the hyperlink in webi reports?

7 Answers   TCS,

---

Can any body will explain about sarrogat key? Thanks in advance...........Prakash

7 Answers  

---

how to do Ad-hoc reporting ?

6 Answers   IBM,

---

what will be the contents for a functional requirements specifications

0 Answers  

---

how to add duplicte rows to the existing report in webi ?

1 Answers   HCL,

---

WHAT IS SYNCHRONIZATION IN BOXI?

2 Answers   HCL,

---