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

How can you access your repository with different user profiles?

2 Answers   TCS,

---

what is maximum scope of analysis --> can we define more than 3 levels?

2 Answers   CTS,

---

Can we do the slice and dice in webintellegence?

5 Answers   IBM,

---

What is a universe?

8 Answers   TCS,

---

Explain in detail about type 2(scd),

0 Answers  

---

---

How many universes will run maximum in single project

1 Answers   HP,

---

plz tell me about BOmain key in detail?

2 Answers  

---

how to coneect to a server in a business objects

1 Answers  

---

What is the definition of derived table ?

2 Answers   JPMorgan Chase,

---

what is drill down?

5 Answers   TCS,

---

please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.

1 Answers   Exilant, Wipro,

---

I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?

3 Answers   IBM,

---