Simple statement
Posted by:
Flo Enne
Date: June 15, 2011 05:21PM
Hi guys,
I've got a relation with three columns: id, round, name
id holds the primary key. Now I want to select all names that are in all rounds.
For example:
id round name
1 1 mike
2 1 stephen
3 2 frank
4 2 mike
So mike is both in round 1 and round 2 and so I want to select him.
How can I do that?
Thanks in advance.
Cheers,
enne
Edited 1 time(s). Last edit at 06/15/2011 05:22PM by Flo Enne.
Subject
Written By
Posted
Simple statement
June 15, 2011 05:21PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.