delete from tablename where rowid not in(select max(rowid) from tablename

How to delete the duplicate colums in a sql table ?

Question Posted / sathyasheelanbe

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Differences between business objects and web intelligence reports?

1143

Explain what are the measure objects?

940

What is difference between webi and infoview?

1179

Explain what would you consider as your biggest achievement and why?

937

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

996

Explain when to use local filter and when to use global filter?

1308

What is Indexing? how did u implement indexing?

2375

How to generate the report from excel sheet?

1125

how to create reports on screech?

2501

In banking domain how many Fact tables,Dimension table are present?

8758

How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

2241

Explain how to schedule the report in b.o?

987

Explain is it the job of a business analyst or systems analyst to draw the class diagram?

986

Explain is data mart?

971

Can we configure two instances of CMS pointing to two different CMS system databases?

1979