순위 rank()

@

rank() over(order by 칼럼명)

 

  ex)   rank() over(order by favorites desc)

 

@그룹별 순위

rank() over(partition by 그룹지을칼럼 order by 칼럼명)

    ex) rank() over(partition by food_type order by favorites desc)