SQL GROUP按日行，然后在DESC中进行分组（仍需要帮助）

Question

Right now i'm just ordering all the rows by DESC, but i want to put the rows that are created the same day into groups and the groups in DESC.

This is what i currenly have:

$sql3 = "SELECT * FROM test3 WHERE aktiv LIKE 'Ja' ORDER BY date DESC ";
$result = mysqli_query($conn, $sql3);

This is my table:

So it will echo out all the rows that where created on 17 first then 16 and 14 into groups, then i can echo out the date of the different groups. So do i need to use GROUP BY or first find the dates then put it into groups.

I have tried different ways of doing it, but its so many different answers around and can't find the right solution for me, so i need a bit of help.

Answer 1

use aggregation function min for id and date for datetime to date

 SELECT date(date) as day,aktiv,betvalue,min(id)
 FROM test3 WHERE aktiv LIKE 'Ja'  group by day,aktiv,betvalue
 ORDER BY date(date) DESC