Answer Detail: RE: Hi all...Can you please tell me how to delet...

GeekInterview.com > Tech FAQs > RDBMS

Print |

Question: Hi all...
Can you please tell me how to delete the duplicate records in a table.

February 02, 2007 05:46:28	#4
	Member Since: Visitor Total Comments: N/A
RE: Hi all...Can you please tell me how to delet...
create table tab2(a int, b int);delete from tab2 a where (a.rowid) > ( sel min(b.rowid) from tab2 b where a.a=b.a);or delete from tab2 a where (a.rowid) < ( sel max(b.rowid) from tab2 b where a.a=b.a);