List<?> findAll();

Page<?> findAll(Pageable pageable)

Page<?> findByName(Pageable pageable);

Page<?> findByNameContainsIgnoreCase(String name, Pageable pageable);

Page<?> findAllByNameContainsIgnoreCaseAndProvince(String name, Province province, Pageable pageable);

/* Entity Class */
@Data
@Entity
@Table(name = "my_sequence")
public class MySequence {
    @Id
    @SequenceGenerator(name = "id_seq", sequenceName = "mq_id_seq", allocationSize = 1)
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "id_seq")
    private Long id;
}

/* Repository */
public interface MySequenceRepo extends JpaRepository<MySequence, Long>  {
    @Query(value = "SELECT nextval('mq_id_seq')", nativeQuery = true)
    Long getNextSeriesId();
}

/* Sample Code */
Long seq = this.mySequenceRepo.getNextSeriesId();