Re: How to compare two records?

[Jassim Rahma]

Hi Peter,

Appreciate your help.. But I corrected the typo and still getting error.


SELECT b.bmi_id, b.bmi_weight, b.prev, b.diff
FROM
(
SELECT max(bmi_id) AS last_bmi FROM bmi WHERE member_id = 100
) AS a
JOIN
(
SELECT bmi_id, bmi_weight, LAG(bmi_weight) over w AS prev, bmi_weight-LAG(bmi_weight) over w AS diff
FROM bmi WHERE member_id = 100 window w AS (ORDER BY bmi_id)
) AS b ON a.last_bmi = b.bmi_id;



Regards, the double datatype, you are 100% right, I changed it to decimal(5,2)