按sku分组，最大日期为SQL

您可以添加其他逻辑以获取最后日期。一种方法是在

WHERe

SELECt s.PROD_CODE AS Sku, l.REC_DATE AS [Last Date],  li.COST AS CostFROM (dbo_LOTS as l INNER JOIN      dbo_SKU as si      ON l.SKU_ID = s.SKU_ID     ) INNER JOIN     dbo_LOT_ITEM as li     ON l.LOT_ID = li.LOT_IDWHERe l.REC_DATE = (SELECt MAX(l2.REC_DATE)         FROM dbo_LOTS as l2         WHERe l2.SKU_ID = l.SKU_ID        );