以下是按partno分组取minprice最小值记录的主键ID,然后再关联获取完整记录
select * from (
select id,row_number() over(partition by partno order by minprice) rowid from Table1
) b where rowid=1
以下是按partno分组取minprice最小值记录的主键ID,然后再关联获取完整记录
select * from (
select id,row_number() over(partition by partno order by minprice) rowid from Table1
) b where rowid=1