获取最近三个用户的所有操作 [英] Get all actions of the last three users

问题描述

我有一个历史记录表，其中存储了用户对延后帖子执行的所有操作

I have a history table that stores all actions done by users on deferments posts

    id     | post_id | action    |  user_id
    1      |  5      | 1         |  3
    2      |  6      | 4         |  1
    3      |  6      | 4         |  4
    4      |  7      | 2         |  6
    5      |  7      | 3         |  2
    6      |  5      | 2         |  3
    7      |  4      | 5         |  3

我想要的是让最后三个用户完成所有操作

What I want is to get all actions done by the last three users

推荐答案

假定ID是AUTO_INCREMENT列，

SELECT  a.user_ID, a.action
FROM    tableName a
        INNER JOIN
        (
            SELECT  DISTINCT user_ID
            FROM    tableName   
            ORDER   BY ID DESC
            LIMIT   3
        ) b ON user_ID = b.user_ID

• SQLFiddle演示
• SQLFiddle Demo

这篇关于获取最近三个用户的所有操作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！