http://www.perlmonks.org?node_id=664269

fernandes has asked for the wisdom of the Perl Monks concerning the following question:

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!