Your skill will accomplish what the force of many cannot |
|
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
Dear Monks,
My table is like: Orange, yellow, 1 Orange, green, 2 Grape, black, 1 Strawberry, blue, 1 Mellon, red, 2 Mellon, white, 1 And I want to select just the rows that repeat the fruits: Orange, yellow, 1 Orange, green, 2 Mellon, red, 1 Mellon, white, 2 And ORDERed BY fruit. I’ve tried subqueries and INTERSECT without good results. Has anyone some advice? The third column does not matter the ORDER. It is like a supermarket ID number. But I want to see only the rows of 1 and 2 supermarkets. This is important because uses a WHERE statement, I think. Thanks! In reply to (OT) Exclusion selection on DBI by fernandes
|
|