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

when to go for alias and when to go for contexts

4 Answers  

---

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

1 Answers   TCS, Wipro,

---

when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report

2 Answers  

---

What task is 98% of the required work of a business analyst?

0 Answers  

---

How to get top 5 rows of a selected column?

3 Answers   Patni,

---

What is difference between merged dimension and forced dimension??

1 Answers  

---

What are the different types of Filters available in BUSINESS OBJECTS?

3 Answers  

---

why we use aggregation in lower level

1 Answers   TCS,

---

When we use aggregate awareness function in designer?

0 Answers  

---

Please anybody tell me Is Data integration And ETL programming is same..? Thanks in advance....

3 Answers  

---

What are steps to be taken care to create a good Universe?

2 Answers  

---

What is the server based ranking? and its usage?

2 Answers  

---