SQL：找到特定日期每个顾客最高购买量：Find the highest purchase amount ordered by the each customer on a particular date， with their ID, order date and highest purchase amount.

 

A：

　　SELECT customer_id,ord_date,MAX(purch_amt) FROM orders GROUP BY customer_id,ord_date;

 

find the highest purchase amount ordered by the each customer on a particular date  with their ID, order date and highest purchase amount.