Computer scienceBackendSpring BootSpring Data

Custom queries with @Query

Query string with sorting

Report a typo

Here is a model class that describes the Movie entity:

@Entity
public class Movie {
    @Id
    @GeneratedValue
    private long id;
    private String name;
    private String country;
    private String director;
    private int releaseYear;

    // constructor, getters, setters
}

We have declared a method findByCountryAndSortByYear to get a list of movies by a specific country and sorted by years:

public interface MovieRepository extends CrudRepository<Movie, Long> {
 
    @Query(value = "____", nativeQuery = true)
    List<Movie> findByCountryAndSortByYear(String country);
}

Which of the following query strings is correct for this method?

Select one option from the list

SELECT * FROM movies WHERE releaseYear = :year

SELECT * FROM movies WHERE country = ?1 ORDER BY country

SELECT m FROM Movie m WHERE m.country = :country ORDER BY m.releaseYear

SELECT * FROM movies WHERE country = ?1 ORDER BY release_year

___

Create a free account to access the full topic