Answer the question
In order to leave comments, you need to log in
How to make a selection on a column from some value to the last available?
There is a table:
id,price,last_update
The last_update stores the timestamp time format, I want to select the price by last_update, suppose I have the following data:
+----+-------+-------------+
| id | price | last_update |
+----+-------+-------------+
| 1 | 500 | 1 |
+----+-------+-------------+
| 2 | 300 | 2 |
+----+-------+-------------+
| 3 | 523 | 3 |
+----+-------+-------------+
| 4 | 543 | 4 |
+----+-------+-------------+
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question