Count the Number of Rows in Spring Data JPA | Baeldung

PHOTO EMBED

Thu Nov 30 2023 20:53:02 GMT+0000 (Coordinated Universal Time)

Saved by @faresmh 

public interface AccountRepository extends JpaRepository<Account, Integer> { 
    long countByUsername(String username);
    long countByPermission(Permission permission); 
    long countByPermissionAndCreatedOnGreaterThan(Permission permission, Timestamp ts)
}
Copy
content_copyCOPY

https://www.baeldung.com/spring-data-jpa-row-count#using-the-jpa-repository