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 any one say me exactly when and where alias and context are used in resolving a loop. If possible try to give me a scenario also.

3 Answers  

---

Explain the difference between detect alias and detect context?

0 Answers  

---

There is one report running and a user wants to know whether data is from detail table or summary table. what is your approach?

1 Answers  

---

u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources

4 Answers   IBM,

---

Explain the data types present in bo and what happens if we implement view in the designer and report?

0 Answers  

---

---

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  

---

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

0 Answers   CTC,

---

Hi , can anybody explain me what is the need of migration ? and how to do it ? could plz explain me in detail?

2 Answers  

---

How to restrict password to a user while sending a document in .pdf format

0 Answers   Mphasis,

---

Explain what is the difference between slice and dice and cross tab report?

0 Answers  

---

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

0 Answers  

---

WHAT IS THE DIFF BETWEEN BO6.5 AND BOXI

5 Answers   TCS,

---