HQL - find the object where property x is the highest

Question

Can I execute HQL queries?

"get a UserEntity where the creationTimestamp property is the last of all UserEntities."

Essentially a request to return the “newest user” to our program, where each UserEntity has a field mapped to a timestamp column in our database.

Answer 1

HQL query for a list of users from the newest:

from UserEntities
order by creationTimestamp desc

Use to restrict the result set to only one user. setMaxResults

Answer 2

The query for the highest value of creationTimestamp will look like this:

from UserEntity where creationTimestamp = max(creationTimestamp)

( ) , query.uniqueResult().

. 14. HQL: .

Answer 3

HQL order-by?