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

what is master-detail report

3 Answers   Patni, TCS,

---

why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.

7 Answers   Satyam,

---

Which versions are used in the bo dashboard work?

0 Answers  

---

Can master data change???if yes then how it'll change.....please explain with example...... thanx

1 Answers  

---

What is the aggrigate navigation ? can anybody explain me with some practical example?

1 Answers  

---

Can anybody tell How a report will burst into .pdf files? Thanks in advance .....Prakash

3 Answers  

---

how do you give security to universe ?

2 Answers   InfoStep, Tech Mahindra,

---

What happens in BO when a user logs in to Infoview and a rich client like webi?

2 Answers   TCS,

---

Can we use unconnected lookup as dynamic lookup?

1 Answers   TCL,

---

What is thin client And thick client..?

2 Answers  

---

How can you access your repository with different user profiles?

2 Answers   TCS,

---

if there are 2 hierarchies 1 is a-b-c and another one is a- c which hierarchy b.o takes while we use drill mode

3 Answers   HP,

---