MySQL last() Function

SELECT LAST(temp_c) FROM readings;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(temp_c) FROM readings' at line 1

SELECT station, read_on, temp_c FROM readings ORDER BY read_on DESC, id DESC LIMIT 1;

SELECT station, read_on, temp_c FROM readings WHERE station = 'PUNE' ORDER BY read_on DESC LIMIT 1;

SELECT station, MAX(read_on) AS last_reading_date FROM readings GROUP BY station;

SELECT station, read_on, temp_c, rain_mm
FROM (
  SELECT r.*, ROW_NUMBER() OVER (PARTITION BY station ORDER BY read_on DESC, id DESC) AS rn
  FROM readings r
) t
WHERE rn = 1
ORDER BY station;

SELECT station, read_on, temp_c,
       LAST_VALUE(temp_c) OVER (PARTITION BY station ORDER BY read_on) AS last_temp_wrong
FROM readings
ORDER BY station, read_on;

SELECT station, read_on, temp_c,
       LAST_VALUE(temp_c) OVER (PARTITION BY station ORDER BY read_on
                                ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS last_temp
FROM readings
ORDER BY station, read_on;

SELECT station, read_on, temp_c,
       LAG(temp_c)  OVER (PARTITION BY station ORDER BY read_on) AS previous_temp,
       temp_c - LAG(temp_c) OVER (PARTITION BY station ORDER BY read_on) AS change_c,
       LEAD(read_on) OVER (PARTITION BY station ORDER BY read_on) AS next_reading
FROM readings
ORDER BY station, read_on;

INSERT INTO readings (station, read_on, temp_c, rain_mm) VALUES ('KOCHI', '2026-03-04', 29.0, 0);
SELECT LAST_INSERT_ID() AS my_new_id;