spring - Spring Data JPA QueryLimit

Question

@Query(value = "SELECT e FROM user Order By e.id DESC LIMIT 0, :n ") List findTopN(@Param("n") long n);

标签： springjpalimit

Answer 1

@Query(value = "SELECT * FROM event_tracker.user Order By user.id DESC LIMIT 0, :n",nativeQuery = true) List findTopN(@Param("n") long n);