How to select the maximum date in MYSQL with one select?

Question

MySQL

There is a table in which there is a field type datetime and timestamp. I need to select the maximum time (datetime type) value. I write:
select info, MAX(date) from table
It gives me the maximum date, everything is OK, but the value of info is from the first line in the result of the selection.
The design works correctly:

Select * from table where date IN (SELECT MAX(`date`) as `time` FROM `table`)

Do I understand correctly that only through a nested select can this be done? Ie in one it is impossible.

Answer 1

you understand correctly: if you need to get all the records with the maximum date, then you can’t do without a subquery.
PS Your question is at odds with the code.

Answer 2

One line?
If all rows have the same maximum date, then yes, a subquery.