Mysql query to group by customer and give the latest activity from each customer10.04.20

SELECT 
c.ca_type AS type                                                                                                                                                                                                                              
,c.ca_cus_name  AS customer                                                                                                                                                                                                                    
,c.ca_comment  AS comment                                                                                                                                                                                                                      
,c.ca_crm AS crm                                                                                                                                                                                                                               ,CAST(c.ca_date AS INT) AS date                                                                                                                                                                                                           
FROM ca  AS c
INNER JOIN
(SELECT ca_cus_name, CAST(MAX(ca_date) AS INT) AS maxdate
FROM ca 
GROUP BY ca_cus_name) AS c2 
ON c.ca_cus_name = c2.ca_cus_name 
AND c.ca_date = c2.maxdate

https://stackoverflow.com/questions/2411559/how-do-i-query-sql-for-a-latest-record-date-for-each-user

Anonymous

Mysql query to group by customer and give the latest activity from each customer10.04.20

Information Epoch 1758178343