DISTINCT ON是一种只想要1个条目的语法。但是如果我想要最新的N个条目呢?我该如何将其转换: CREATE VIEW your_view ASFROM your_table a
ORDER BY id, date DESC; 而是为了 “按id选择最新的n=2条目”而不是“按id选择最新的n=1条目?”?
DISTINCTn FROM Notes n WHERE n.messageId = :messageId AND n.group=group], line 1, column 74: unexpectedn FROM Notes n"),
@NamedQuery(name = "Notes.findById", query = "SELECTn FROM Note