使用MySQL进行SQL查询

使用MySQL进行SQL查询

我认为您是

Deliverable

从

Task

ID的顺序中查询前3位。您可以尝试这样的事情：

编辑： 确定，我将再对此刺一击。这应该给你的前3

Deliverable

小号下令

Task.id

采取只

Deliverable

关联到

max(Task.id)

deliverables =         (List<Deliverable>) session.createQuery( "from Deliverable as d, Task as t     where t.deliverable.id = d.id and     t.id = (select max(t1.id) from Task t1 where t1.deliverable.id = d.id)     and d.project.id= :id     and t.user.username = :name     order by t.id desc")        .setMaxResults(3)        .setLong("id", projectId)        .setString("name", username)        .list();