我有以下查询:
select ema.es_symbol as symbol, ema.score as score, ema.weight as weight, rsi.relative_strength_index as relative_strength_index
from ema_score ema, relative_strength_index rsi inner join
(select rsi_symbol, max(rsi_date) as maxDate from relative_strength_index group by rsi_symbol) rsiDate
on rsi.rsi_symbol = rsiDate.rsi_symbol
and rsi.rsi_date = rsiDate.maxDate
where ema.es_symbol = rsi.rsi_symbol
and ema.score not in (0,1,10,11)
and rsi.relative_strength_index not in (0,100);
我正在尝试添加一个计算列,就像下面这个作为最后一列:
ema.weight/max(ema.weight)
我想要的结果是每个符号的重量除以重量列中的最大重量。当我按照我的方式尝试时,我只收到了一行结果。我在这里做错了什么?