79647198

Date: 2025-06-01 04:48:53
Score: 2.5
Natty:
Report link

How about using LAST_VALUE() ?

SELECT 
    Country, 
    LAST_VALUE(Date) OVER (PARTITION BY Country ORDER BY Date 
        ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS Last_Date, 
    LAST_VALUE(Rate) OVER (PARTITION BY Country ORDER BY Date 
        ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS Last_Rate 
FROM my_tab;
Reasons:
  • Has code block (-0.5):
  • Ends in question mark (2):
  • Starts with a question (0.5): How
  • Low reputation (0.5):
Posted by: Nanomachines Son