15,856 reputation
634102
bio website isworthy.wordpress.com
location Plantation, FL
age 36
visits member for 3 years, 9 months
seen Sep 26 at 20:06

Jun
30
awarded  Nice Answer
Jun
14
awarded  Popular Question
May
15
awarded  Famous Question
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