Home » Developer & Programmer » Forms » how to delete duplicate rows...
how to delete duplicate rows... [message #82274] Wed, 14 May 2003 23:01 Go to next message
Sam
Messages: 255
Registered: April 2000
Senior Member
can anybody help me out

"how to delete duplicate rows for a particular column"

thanx

sam.

Report message to a moderator

Re: how to delete duplicate rows... [message #82280 is a reply to message #82274] Thu, 15 May 2003 00:59 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
See the x other posts regarding the same question.

Report message to a moderator

Re: how to delete duplicate rows... [message #82297 is a reply to message #82280] Fri, 16 May 2003 00:09 Go to previous message
BIRENDER KUMAR
Messages: 18
Registered: May 2003
Junior Member
It's simple just select rowid of the records and delete it by using rowid.
for example:
select rowid,col1 from tablename;
delete from tablename where rowid=' ';
This will work fine.

Report message to a moderator

Previous Topic: Attachment of world filE!!!!!!!!!!!!!!!!!!!
Next Topic: Menu
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 21:47:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.