How to delete the duplicate colums in a sql table ?

Answers were Sorted based on User's Feedback



How to delete the duplicate colums in a sql table ?..

Answer / san

It's not at all possible to create duplicate columns in a
SQL table. The how can we delete the duplicate columns?

Is This Answer Correct ?    10 Yes 0 No

How to delete the duplicate colums in a sql table ?..

Answer / sathyasheelanbe

delete from tablename where rowid not in(select max(rowid)
from tablename group by primary key columnname)

Is This Answer Correct ?    2 Yes 0 No

How to delete the duplicate colums in a sql table ?..

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

Is This Answer Correct ?    3 Yes 4 No

Post New Answer

More Business Objects Interview Questions

What is the difference between slice and dice and cross tab report?

0 Answers  


Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

0 Answers  


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

0 Answers   Mphasis,


What is thin client And thick client..?

2 Answers  


IF I WANT TO INSTALL BO ENTERPRISE PRODUCTS IN WINDOWS 2000 PROFESSIONAL SERVER ,WHAT SHOULD BE THE SYSTEM CONFIGURATION?

1 Answers   AG Technologies,


There are 2 types of strategies are there? 1. Built-in Strategy 2. External Strategy can you please explain them in complete that what are these? Thanks in Advance

1 Answers  


what are they different types of report in BO?

6 Answers  


Can anyone tell me how to display (calculate )Turn Around Time between two dates in the BO Report? Thanks in Advance

1 Answers  


Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

0 Answers  


Is it possible to generate reports without having knowledge of the Universe structure?

4 Answers  


How to change the order of prompts in universe?

3 Answers  


how did u give developed universe to ur client?

1 Answers  


Categories