select name,count(*) as num,Loc from Test group by name
如果是MSSQL 采用ROW_NUMBER()Select A.Name,A.Qty,A.Loc From ( select *,ROW_NUMBER() over(partition by [Name] order by Qty) AS RowNumber from Test ) A Where A.RowNumber = 1
试试: select * from 表 where (name, qty) in ( SELECT NAME, MIN(QTY) FROM 表 GROUP BY NAME )
select * from ( Select name,qty, loc, row_number() over (partition by name order by qty) as row_number from 表 ) where row_number = 1
采用ROW_NUMBER()Select A.Name,A.Qty,A.Loc From
(
select *,ROW_NUMBER() over(partition by [Name] order by Qty) AS RowNumber from Test
) A
Where A.RowNumber = 1
select * from 表
where (name, qty) in
(
SELECT NAME, MIN(QTY) FROM 表 GROUP BY NAME
)
select * from
(
Select name,qty, loc, row_number() over (partition by name order by qty) as row_number from 表
)
where row_number = 1