View original (French)

Most Recent Date Sql

franksh Posted messages 54 Status Member -  
jee pee Posted messages 9429 Registration date   Status Moderator Last intervention   -
Hello,

I'm trying to get the most recent date from my table with no success, here is my query 

 SELECT *, MAX(date_message) FROM conversations LEFT JOIN users ON users.id = conversations.id_sender WHERE id_receiver = 350 GROUP BY id_sender


Configuration: Windows / Chrome 67.0.3396.99

1 answer

Answer 1 / 1
jee pee Posted messages 9429 Registration date   Status Moderator Last intervention   9 966
 
Hello,

On a 
group by
, you can't have all the fields, try 

SELECT id_sender, MAX(date_message)


--
        a stranger is a friend we haven't met yet.
0