mysql - 获取数据库中的最后5行，并按ASC排序

如何获取数据库中的最后5行并将其升序排序？这是我的代码：

$this->query("
    SELECT  `chat`.`message`,
            `users`.`username`,
            `users`.`user_id`
    FROM    `chat`
    JOIN    `users`
    ON      `chat`.`user_id` = `users`.`user_id`
    ORDER BY `chat`.`timestamp`
    DESC
    LIMIT 5
");

最佳答案

select * from (
    SELECT  `chat`.`message`,
            `users`.`username`,
            `users`.`user_id`,
            `chat`.`timestamp`
    FROM    `chat`
    JOIN    `users`
    ON      `chat`.`user_id` = `users`.`user_id`
    ORDER BY `chat`.`timestamp`
    DESC
    LIMIT 5
)
order by timestamp asc