15,826 reputation
634102
bio website isworthy.wordpress.com
location Plantation, FL
age 36
visits member for 3 years, 8 months
seen yesterday

Apr
13
awarded  Enlightened
Apr
13
awarded  Nice Answer
Apr
9
awarded  Nice Question
Apr
7
awarded  Great Answer
Mar
31
awarded  Popular Question
Mar
21
awarded  Notable Question
Mar
12
asked What is meant by the RMAN Duplicate “noncurrent point in time”?
Mar
11
answered SQLPlus Padding in Query Results
Mar
11
asked SQLPlus Padding in Query Results
Feb
12
awarded  Notable Question
Jan
18
awarded  Notable Question
Jan
16
awarded  Notable Question
Jan
4
awarded  Yearling
Dec
28
awarded  Nice Answer
Dec
16
comment How to check for mutiple rows with same data?
I understood "not select data of multiple rows" to mean that no rows identical to another should be included. This would apply to both the the first (being duplicate of the second) and the second (being a duplicate of the first). If the intention intention of the OP (or the reader) was to eliminate only the secondary instance of the row, then an analytic like yours would be the route to go. (+1)
Dec
9
comment Eliminate duplicates in ListAgg (Oracle)
This query does not return the requested results. It returns the same results as SELECT * FROM ListAggTest;.
Nov
30
awarded  Notable Question
Nov
26
comment Optimal value for LOG_BUFFER parameter
Related: asktom.oracle.com/pls/apex/…
Nov
25
revised Optimal value for LOG_BUFFER parameter
deleted 2 characters in body
Nov
18
comment Why is Database Administration so hard?
@Chris Travers To some extent yes, but a good DBA interacts far more with developers and their application code than would a sysadmin.