您好,我有这个查询,以获取基于前一行的费率:
SELECT
t.*,
100 * (Volumen - Volumen_a) / (Volumen_a) Subida
FROM (
SELECT
*,
(
SELECT Volumen
FROM ejemplo t_ant
WHERE
t_ant.Sujeto = t_act.Sujeto AND t_ant.Id < t_act.Id
ORDER BY Id DESC
LIMIT 1
) Volumen_a
FROM ejemplo t_act
WHERE Sujeto = 'HGT'
ORDER BY Fecha DESC
LIMIT 1
) t
WHERE Volumen_a IS NOT NULL;它只是显示了最后一行...然后我需要它给我显示所有的行。
诚挚的问候
https://stackoverflow.com/questions/51393120
复制相似问题