Eliminate duplicate rows from table
Delete from EMP a Where a.rowid <> (select min (b.rowid) from emp b where a.empno = b.empno); OR Delete from EMP a Where a.rowid <> (select max (b.rowid) from emp b where a.empno = b.empno);
skip to main |
skip to sidebar
ORACLE DEVELOPER
Labels
- connect by prior (1)
- DECODE FUNCTION IN ORACLE (1)
- Difference between database triggers and form triggers? (1)
- Difference between procedure and function. (1)
- Differentiate between TRUNCATE and DELETE. (1)
- Eliminate duplicate rows from table (1)
- Second Largest Number (1)
- What are cursor attributes? (1)
Blog Archive
-
▼
2009
(15)
-
▼
June
(10)
- Eliminate duplicate rows from table
- DECODE FUNCTION IN ORACLE
- connect by prior
- CO-RELATED SUBQUERY
- To know the current week of the year
- Second Largest Number
- What are cursor attributes?
- Difference between procedure and function.
- Difference between database triggers and form trig...
- Differentiate between TRUNCATE and DELETE.
-
▼
June
(10)
Share
Recent Posts
Blogger Tricks
Blogger Themes
Tags
- connect by prior (1)
- DECODE FUNCTION IN ORACLE (1)
- Difference between database triggers and form triggers? (1)
- Difference between procedure and function. (1)
- Differentiate between TRUNCATE and DELETE. (1)
- Eliminate duplicate rows from table (1)
- Second Largest Number (1)
- What are cursor attributes? (1)
Download
Labels
- connect by prior (1)
- DECODE FUNCTION IN ORACLE (1)
- Difference between database triggers and form triggers? (1)
- Difference between procedure and function. (1)
- Differentiate between TRUNCATE and DELETE. (1)
- Eliminate duplicate rows from table (1)
- Second Largest Number (1)
- What are cursor attributes? (1)
0 comments:
Post a Comment