Mang May Tinh
Dec 6, 2007
Delete duplicate rows in Table - Oracle
delete from TABLE_NAME t1
where t1.rowid >
( select min(t2.rowid) from TABLE_NAME t2
where t1.COLUMN_1 = t2.COLUMN_1
and t1.COLUMN_2 = t2.COLUMN_2);
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Nhạc
Nhạc
Theo bước cha
Học tiếng Nhật
Học tin học
Nụ cười
Labels
apache
Browser
Common
Database
Distributed Protocol
Ecommerce
Host and Domain
java
Jdeveloper
JSF
Linux
Milestone
Network Security Hacks
Oracle
Overview
Perl Programming Language
PL/SQL
Print
SED
Server Management
SOA
Spring
Struts
System Administration
Technical Summary
Tools
Utility
Web Service
windows
Blog Archive
►
2016
(1)
►
October
(1)
►
2008
(13)
►
August
(1)
►
June
(3)
►
May
(3)
►
March
(4)
►
February
(2)
▼
2007
(70)
▼
December
(4)
Sticky Note
Change Language in Oracle in Windows
Change Language in JDeveloper
Delete duplicate rows in Table - Oracle
►
October
(8)
►
September
(6)
►
August
(8)
►
July
(10)
►
June
(7)
►
May
(21)
►
April
(6)
No comments:
Post a Comment