Is it possible to use the max function with between?

Question

SQL

How it is possible to modernize request that from the specified period to find the maximum value?

SELECT * FROM session WHERE date BETWEEN '2020.05.01' AND '2020.07.01'

Answer 1

SELECT MAX(date) FROM session WHERE date BETWEEN '2020.05.01' AND '2020.07.01'

SELECT TOP 1 date 
  FROM session 
  WHERE date BETWEEN '2020.05.01' AND '2020.07.01'
  ORDER BY 1 DESC