字符串查詢
@Query("select max(substring(s.code, CHAR_LENGTH(:codePrefix)+1)) from Student s where s.code like concat(:codePrefix, '%')")
public String findMaxCode(@Param("codePrefix") String codePrefix);
@Query("select max(substring(s.code, CHAR_LENGTH(:codePrefix)+1)) from Student s where s.code like concat(:codePrefix, '%')")
public String findMaxCode(@Param("codePrefix") String codePrefix);