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!
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: (OT) Exclusion selection on DBI
by moritz (Cardinal) on Jan 25, 2008 at 11:47 UTC | |
by fernandes (Monk) on Jan 25, 2008 at 12:37 UTC | |
by mpeppler (Vicar) on Jan 25, 2008 at 13:21 UTC | |
by roboticus (Chancellor) on Jan 25, 2008 at 12:57 UTC | |
Re: (OT) Exclusion selection on DBI
by mpeppler (Vicar) on Jan 25, 2008 at 11:51 UTC | |
by roboticus (Chancellor) on Jan 25, 2008 at 13:04 UTC | |
by mpeppler (Vicar) on Jan 25, 2008 at 13:16 UTC | |
by fernandes (Monk) on Jan 25, 2008 at 14:08 UTC | |
by moritz (Cardinal) on Jan 25, 2008 at 14:14 UTC | |
Re: (OT) Exclusion selection on DBI
by erix (Prior) on Jan 25, 2008 at 15:04 UTC |
Back to
Seekers of Perl Wisdom