SELECT 订单日期,供应商,销售组 FROM [dbo].[ERP导入] order by 订单日期 ASC
这个是SQLSERVER的
然后我需要看这个供应商 最小的订单日期 对应的哪个销售组
SELECT 供应商,销售组,min(订单日期) as 最小日期 FROM [dbo].[ERP导入] group by 供应商,销售组
SELECT 订单日期,供应商,销售组 FROM [dbo].[ERP导入]
where 订单日期=(SELECT min(订单日期) FROM [dbo].[ERP导入] )
order by 订单日期 ASC
with a as(
select min(订单日期) as 订单日期,供应商 from [dbo].[ERP导入] group by 供应商
)
select t2.订单日期,t2.供应商,t1.销售组
from [dbo].[ERP导入] t1 left join a t2 on t1.订单日期=t2.订单日期 and t1.供应商=t2.供应商
order by t2.订单日期 ASC
SELECT a.订单日期,a.供应商,a.销售组
FROM [dbo].[ERP导入] a
inner join (SELECT 供应商,min(订单日期) as 订单日期 FROM [dbo].[ERP导入] group by 供应商) b
on a.供应商=b.供应商 and a.订单日期=b.订单日期