尝试使用JPA获得前10个结果：使用***@Param（“patientId”）作为NamedParameters**

List <notification> = notif.createQuery("select * from notification where patientId = :patientId order by patient_id")
    .setFirstResult(0) 
    .setMaxResults(10) 
    .getResultList();

或者使用***可分页***：

Page<notification> findAll(Pageable pageable);
...
Page<notification> notification = NotificationRepository.findAll(PageRequest.of(0, 10));

别忘了你的命令

https://docs.spring.io/spring-data/jpa/docs/current/reference/html/#repositories.limit-query-result

Page<Notification> queryFirst10ByPatientId(long patientId, Pageable pageable);
Slice<Notification> findTop10ByPatientId(long patientId, Pageable pageable);
List<Notification> findFirst10ByPatientId(long patientId, Sort sort);
List<Notification> findTop10ByPatientId(long patientId, Pageable pageable);