[MySql] Select (max) che funziona a metà

[optime]

Confronta queste due query

SELECT Max(data),       tipo,
       note
FROM   table1
GROUP  BY idcli

SELECT *
FROM   table1 T1
       JOIN (SELECT Max(data) AS Data,
                    idcli
             FROM   table1
             GROUP  BY idcli) T2
         ON T1.data = T2.data
            AND T1.idcli = T2.idcli

http://sqlfiddle.com/#!9/da1ae4d/5