php - SQL - 选择具有公共(public)列值的最近 x 行

Question

示例

我想从下表中选择具有相同组值的最近 5 行。

--------------------------------------------
|    id    |    group    |    timestamp    |
--------------------------------------------
|    1     |    circle   |    1468287300   |
|    2     |    square   |    1468287816   |
|    3     |    square   |    1468287694   |
|    4     |    circle   |    1468287252   |
|    5     |    circle   |    1468287987   |
|    6     |    circle   |    1468287068   |
|    7     |    square   |    1468287149   |
|    8     |    circle   |    1468287422   |
--------------------------------------------

Answer 1

我认为这应该有效，请检查并告诉我

SELECT * FROM Table1 GROUP BY group ORDER BY timestamp DESC LIMIT 5;