Hive sql 常见面试题-排列问题

现有球队表（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