本文共 688 字，大约阅读时间需要 2 分钟。

题目：（困难）

标签：SQL

解法一：

SELECT username, activity, startDate, endDateFROM UserActivityWHERE (username, startDate) IN (SELECT username, max(startDate)                                FROM UserActivity                                WHERE (username, startDate) NOT IN (SELECT username, max(startDate)                                                                    FROM UserActivity                                                                    GROUP BY username                                                                    HAVING COUNT(username) > 1)                                GROUP BY username);

转载地址：https://dataartist.blog.csdn.net/article/details/110421698 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！