CREATE TABLE TEAM(team_id NUMBER, team_name VARCHAR2(20))
/
INSERT INTO TEAM (SELECT 1,'TeamA' FROM DUAL UNION SELECT 2,'TeamB' FROM DUAL UNION SELECT 1,'TeamC' FROM DUAL)
/
COMMIT
/
SELECT * FROM TEAM
/
/*Team_id		Team_Name
------------------------
1		TeamA
2		TeamB
3		TeamC

*/

SQL> select t1.team_name, t2.team_name
  2  from team t1, team t2
  3  where t1.team_id < t2.team_id
  4  order by t1.team_name;

TEAM_NAME            TEAM_NAME
-------------------- --------------------
TeamA                TeamB
TeamA                TeamC
TeamB                TeamC

SQL>