Try:
delete from Table_1 t
where rowid != ( select min(rowid)
from Table_2
where YourID = t.YourID );
In your case since you've got only one table, Table_1
and Table_2 will equal your table.
Regards,
--
dk
--- kumar Devan <[EMAIL PROTECTED]> wrote:
> Hi all,
> I am having one table in that there is no
> unique,primary key ...
> In that table there are dublicates entries of the
> rows, i need to delete
> the duplicate rows in that table and row will
> contain unique entries only..
> please let me know the solution to delete the
> dublicate rows.
> Thanks & Regards,
> Devan.
>
>
> [Non-text portions of this message have been
> removed]
>
>
__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/HKFolB/TM
--------------------------------------------------------------------~->
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
