【LeetCode2118. 建立方程】 group_concat指定分隔符，指定排序顺序
目录
- 题目地址
- 题目描述
- 代码
题目地址
https://leetcode.cn/problems/build-the-equation/description/
题目描述
Example 2:
输入:
Terms 表:
+-------+--------+
| power | factor |
+-------+--------+
| 4 | -4 |
| 2 | 1 |
| 1 | -1 |
+-------+--------+
输出:
+-----------------+
| equation |
+-----------------+
| -4X^4+1X^2-1X=0 |
+-----------------+
代码
with t0 as(
select power, (case when factor>0 then concat("+",factor) else factor end) as factor
from Terms
)
,
t1 as(
select *,
(case when power=0 then factor when power=1 then concat(factor,"X")
else concat(factor, "X^", power ) end ) as term
from t0
order by power desc
)
select concat( group_concat(term order by power desc separator ""), "=0") as equation
from t1