Recover the highest value in a column according to the repetition of the second

Question

Good night to you all!

I have a system in my company that records an entire value in a table every moment of the day. It also records the date and time in Datetime format;

The table in the bank is as follows:

As you can see in the date column it repeats the date. I need to perform a query in that Mysql database where return the largest amount per day. In this case the above query would have to return as follows:

Thank you for your attention!

Database: Mysql 5

Answer 1

Try to use it as follows:

SELECT MAX(QTD), DATA FROM TABELA GROUP BY DATA