Go4Oracle

Member Login

You are here :Home

Forum

	FireBoard	Forum Threaded View

Welcome, Guest
Please Login or Register. Lost Password?

duplicate row delete in one command (1 viewing) (1) Guest

Forum for Novice Oracle Users

Favoured: 0

TOPIC: duplicate row delete in one command

Forum Tools

#10

dubey (User)

Fresh Boarder

Posts: 2

duplicate row delete in one command 4 Months ago	Karma: -1
sir i think this question's ans is delete from table name where rowid not in (select min(rowid) from table name group by all collumn);

Report to moderator Logged

Logged

The administrator has disabled public write access.

#11

amal (Moderator)

Moderator

Posts: 2

Re:duplicate row delete in one command 4 Months ago	Karma: 0
Your answer is right (logic) you can practice it with an actual delete statement with some dummy data generated in the table as duplicated records....and see if that works in case you find any error do let me know.. DO u Think GROUP BY CLAUSE IN THIS delete Statement IS Necessary