现有球队表(team)如下。
拿到所有球队比赛的组合 每个队只比一次
期望结果如下:
查询sql
with t as (SELECT team_name, case team_name WHEN '勇士' then 1 WHEN '湖人' then 2 WHEN '灰熊' then 3 else 4 end num FROM team)
SELECT t1.team_name team_name_1, t2.team_name team_name_2 FROM t t1 JOIN t t2 WHERE t1.num<t2.num