Why are strings not reversed?

Question

Spring

I want to find the last record in the table flag (id, flag, activity_time)
something like SELECT * FROM flag ORDER BY id DESC;
To do this, I want to write a JPA query, several attempts did not lead to success:

Flag findDistinctTopByIdNotNull();
Flag findDistinctFirstByIdNotNull();
List<Flag> findDistinctByActivityTimeNotNull();
List<Flag> findDistinctFlagByIdNotNull();

what I have in the table:

id: 5, flag: 0, date: 2021-09-07T15:06:53.034
id: 6, flag: 1, date: 2021-09-07T15:07:02.280
id: 7, flag: 1, date: 2021-09-07T15:07:51.791
id: 8, flag: 1, date: 2021-09-07T15:07:52.814
id: 9, flag: 0, date: 2021-09-07T15:08:53.907
id: 10, flag: 1, date: 2021-09-07T15:09:11.626
id: 11, flag: 0, date: 2021-09-07T15:11:48.687
id: 12, flag: 0, date: 2021-09-07T15:12:49.946
id: 15, flag: 0, date: 2021-09-07T15:27:01.824
id: 16, flag: 1, date: 2021-09-07T15:27:42.233
id: 17, flag: 0, date: 2021-09-07T15:27:44.949
id: 18, flag: 1, date: 2021-09-07T15:28:35.762
id: 19, flag: 0, date: 2021-09-07T15:28:38.661
id: 21, flag: 1, date: 2021-09-07T15:29:39.575
id: 22, flag: 0, date: 2021-09-07T15:29:42.405
id: 23, flag: 1, date: 2021-09-07T15:31:42.663
id: 24, flag: 1, date: 2021-09-07T15:50:38.024
id: 25, flag: 1, date: 2021-09-07T15:51:41.298

that they give me all the requests that I tried:

id: 17, flag: 0, date: 2021-09-07T15:27:44.949
id: 10, flag: 1, date: 2021-09-07T15:09:11.626
id: 25, flag: 1, date: 2021-09-07T15:51:41.298
id: 11, flag: 0, date: 2021-09-07T15:11:48.687
id: 5, flag: 0, date: 2021-09-07T15:06:53.034
id: 6, flag: 1, date: 2021-09-07T15:07:02.280
id: 7, flag: 1, date: 2021-09-07T15:07:51.791
id: 24, flag: 1, date: 2021-09-07T15:50:38.024
id: 19, flag: 0, date: 2021-09-07T15:28:38.661
id: 16, flag: 1, date: 2021-09-07T15:27:42.233
id: 23, flag: 1, date: 2021-09-07T15:31:42.663
id: 12, flag: 0, date: 2021-09-07T15:12:49.946
id: 8, flag: 1, date: 2021-09-07T15:07:52.814
id: 15, flag: 0, date: 2021-09-07T15:27:01.824
id: 9, flag: 0, date: 2021-09-07T15:08:53.907
id: 21, flag: 1, date: 2021-09-07T15:29:39.575
id: 18, flag: 1, date: 2021-09-07T15:28:35.762
id: 22, flag: 0, date: 2021-09-07T15:29:42.405

It would be cool to output one most recent record using JPA

Answer 1

https://docs.spring.io/spring-data/jpa/docs/1.5.0....
Here you can find the syntax