[ms sql] 그룹별 최근데이터 조회

select row_number() over(partition by 그룹별 동일한데이터가 입력된 필드(FK) order by 조회할 최대값 대상 필드) as number

from YearlyPay

 

 

ex) 상품별 높은가격만 조회 

select row_number() over(partition by goodsnum order by Price desc) as number, goodsnum , Price

from goodsList where state = '판매중'