About sql take maximum date

alleen

For example:

Number of customers date
Zhang San 100 2016-02-25
Li Si 200 2016-03-21
Zhang San 50 2016-10-21
Zhang San 150 2016-09-14
Li Si 100 2016-06-26

Hopefully the result is:

Number of customers date
Zhang San 300 2016-10-21
Li Si 300 2016-06-26

maggic

group by

likepaopao

First have a master ID

justindx

select customer, sum (quantity) as a1, max (date) as a2 from table group by customer

alleen

The statement is like this

select right(customer,len(customer)-charindex('-',customer)) as customer, quantity, date
FROM
(
    select distinct customers, null as quantity, date from tb_cat
    union
    select customer+'-'+product number, sum (quantity), date from tb_cat group by customer, product number
) T
order by customer