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 isolated joins in check integrity

2 Answers   Accenture, Polaris,

---

How do u get requirement from the client? in what format?

1 Answers   TCS, Wipro,

---

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

1 Answers  

---

What is a join? Explain different types of joins?

5 Answers  

---

Can anybody explain me ? without creating the alias can we resolve the fantrap?

4 Answers  

---

difference between web intelligence,crystal reports and desktop intelligents

4 Answers  

---

explain in detail about type 3?

0 Answers  

---

how many user were there

1 Answers  

---

What we need to discuss with designer before starting the universe designing.

0 Answers   BMC,

---

What is the Drill filter and it's usage?

2 Answers  

---

REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.

0 Answers  

---

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

1 Answers   Wipro,

---