15,561 reputation
53297
bio website isworthy.wordpress.com
location Plantation, FL
age 36
visits member for 3 years, 6 months
seen May 15 at 18:31

Jul
2
awarded  Inquisitive
Jul
2
awarded  Curious
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)