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!
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!
Back to
Seekers of Perl Wisdom