First add an Identity Column in table Alter table <tblname> Add

how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used

Question Posted / arif jameel

11 Answers
18878 Views
UST, I also Faced
E-Mail Answers

Answer Posted / arif jameel

First add an Identity Column in table

Alter table <tblname>
Add < New_columnID > int identity(1,1)

Delete from <tblname> where < New_columnID> in
(select max(New_columnID)from <tblname>
Group by <tbl_columnname>
having count (<tbl_columnname>)>1)

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

902

What is sqlerrm?

888

Is inner join faster than left join?

1135

How do we accept inputs from user during runtime?

1009

What is the difference between truncate and drop statements?

1104

What is sql profiling in oracle?

1010

Which version of sql do I have?

1011

What are pl/sql packages?

1047

How long will it take to learn pl sql?

900

What is offset in sql query?

1083

What is %type in sql?

927

What is online transaction processing (oltp)?

971

what are integrity rules?

981

What is a function in oracle pl sql?

995

What programs use sql?

952