Spring Data JPA GreaterThan Query Method Example

In this tutorial, we will learn how to write a GreaterThan query method or finder method using Spring Data JPA.

Spring Data JPA offers developers an incredibly user-friendly way to create queries using method names. By following a set of conventions, you can define queries without having to write the actual SQL or JPQL. One such keyword provided by Spring Data JPA is GreaterThan, which allows filtering results based on whether a field's value is greater than a specified value.

Maven Dependencies

Create a Spring boot project and add the following maven dependencies to it:



Product Entity

Let's first create a Product entity class and add the following content to it:

package com.springdatajpa.springboot.entity;

import lombok.*;
import org.hibernate.annotations.CreationTimestamp;
import org.hibernate.annotations.UpdateTimestamp;

import jakarta.persistence.*;
import java.math.BigDecimal;
import java.time.LocalDateTime;

        name = "products",
        schema = "ecommerce",
        uniqueConstraints = {
                        name = "sku_unique",
                        columnNames = "stock_keeping_unit"
public class Product {

            strategy = GenerationType.IDENTITY
    private Long id;

    @Column(name = "stock_keeping_unit", nullable = false)
    private String sku;

    @Column(nullable = false)
    private String name;

    private String description;
    private BigDecimal price;
    private boolean active;
    private String imageUrl;

    private LocalDateTime dateCreated;

    private LocalDateTime lastUpdated;


Let's create ProductRepository which extends JpaRepository and add the following code to it:
package com.springdatajpa.springboot.repository;

import com.springdatajpa.springboot.entity.Product;
import org.springframework.data.jpa.repository.JpaRepository;
import java.math.BigDecimal;

public interface ProductRepository extends JpaRepository<Product, Long> {
     * Return the products whose price is greater than given price as method parameter
     * @param price
     * @return
    List<Product> findByPriceGreaterThan(BigDecimal price);
Query method to find or retrieve products whose price is greater than the given price as a method parameter:
    List<Product> findByPriceGreaterThan(BigDecimal price);

Configure MySQL and Hibernate Properties

Let's use the MySQL database to store and retrieve the data in this example and we gonna use Hibernate properties to create and drop tables.

Open the application.properties file and add the following configuration to it:


spring.jpa.hibernate.ddl-auto = create-drop

Make sure that you will create an ecommerce database before running the Spring boot application. Also, change the MySQL username and password as per your MySQL installation on your machine.

Testing Spring Data JPA - GreaterThan Query Method

Let's write the JUnit test to test Spring Data JPA - GreaterThan Query Method:

package com.springdatajpa.springboot.repository;

import com.springdatajpa.springboot.entity.Product;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.math.BigDecimal;

public class QueryMethodsTest {

    private ProductRepository productRepository;

    void findByPriceGreaterThanMethod(){
        List<Product> products = productRepository.findByPriceGreaterThan(new BigDecimal(100));
        products.forEach((p) -> {

Here is the output of the above JUnit test:

Related Spring Data JPA Examples