阅读背景:

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;  SELECT customer_id,ord_date,MAX(purc




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: