强调行具有最大的行量为一个客户。 如何得到输出报表仅行强调了??
选择的名称,订单编号、日期、 (ROW_NUMBER()过(分区的名字,以便通过日期))作为rn 从表;
你可以使用子查询或CTE:
WITH data AS (
select name, order_id, date, (ROW_NUMBER () OVER (PARTITION BY name,order id
ORDER BY date)) as rn from table),
last_entry AS (SELECT name, max(rn) AS rn FROM d GROUP BY name)
SELECT data.*
FROM data JOIN last_entry
ON last_entry.name = data.name
AND last_entry.rn = data.rn;