Select Top 1 records from MS SQL using Spring Data JPA

Question

I am using the below @Query annotation to get the first few record from MS-SQL. It's showing error saying "< operator > or AS expected..."

   @Query("SELECT Top 1 * FROM NEVS010_VEH_ACTV_COMMAND C WHERE C.EVS014_VIN = :vin ORDER BY C.EVS010_CREATE_S DESC")
    CommandStatus findCommandStatusByVinOrderByCreatedTimestampDesc(@Param("vin") String vin);

Answer 1

You can also use findFirst and findTop as mentioned in the Docs:

findFirstByVinOrderByCreatedTimestampDesc(String vin)