在Java中根据datetime获得最多记录排序？

Question

这是我在我的存储库中的查询，我使用的数据库是mysql。

@Query(
    value =
            "select a.id as Id, a.created as createdAt, :emailId as emailId from address a where a.created_by= :createdAT  group by a.id ,
    nativeQuery = true
)
List<Response> getData(Long id, String mail);

现在我的要求是获取顶部的最新记录，按created_at排序

Answer 1

您必须将顺序按而不是分组按并将列表 更改为response，因为您需要单行...

@Query(
    value =
            "SELECT a.id as Id, a.created as createdAt, a.emailId as emailId FROM address AS a ORDER BY a.created" ,
    nativeQuery = true
)
Response getData();