pentru a nu mai deschide un subiect nou care seamana cu acesta, postez in continuarea acestuia
tableTest
+-----------+--------+------------+
| IdClient | IdUser | Data |
+-----------+--------+------------+
| 4 | 0 | 2010-01-01 |
| 3 | 78 | 2016-02-25 |
| 3 | 2 | 2018-03-12 |
+-----------+--------+------------+
SELECT
IdClient
IdUser
MAX(Data) as Data
FROM tableTest
WHERE IdClient = 3
GROUP BY IdClient
In testul meu imi returneaza IdUser 3, cu ultima data 2018-03-12 insa ramane IdUser 78
Cum pot face sa imi returneze si IdUser-ul aferent celei mai mari dati?
SELECT t1.*
FROM tableTest t1
INNER JOIN ( SELECT
IdClient
IdUser
MAX(Data) as Data
FROM tableTest
GROUP BY IdClient) t2
ON t1.IdClient = t2.IdClient AND t1.Data = t2.Data