You can use LAG function, but it requires MySQL 8+. Consider the following data. CREATE TABLE my_table ( id int, temp int, dt timestamp ) ...
確定! 回上一頁