SELECT
TO_NUMBER ( price )/ TO_NUMBER ( price )
FROM
ttt
WHERE
id IN ( '1', '2' ));
回答 0
暂无回答
Dora
这样符合不
WITH ttt as ( select 1 as c1,20 as c2 union select 2 as c1,10 as c2 from dual )
SELECT MAX(CASE WHEN c1 = '1' THEN TO_NUMBER(c2) END) / MAX(CASE WHEN c1 = '2' THEN TO_NUMBER(c2) END)
FROM ttt
发布于
2024/03/11 18:49
泓蓁
要达到什么效果呢？同一个表同一个时间点同一个列它就是完全一样的，除得1不是正常的吗
发布于
2024/03/11 22:09
输入法
用行列转置试试
select "1" as a,"2" as "b" ,"1"/"2" from ttt pivot ( sum( price ) FOR id IN (1,2));
这样符合不