달나라 노트

RANK() OVER() 예시 테이블 Table Name : salary_list id part name salary 1 First_Part One 1000 2 First_Part Two 1900 3 First_Part Three 1400 4 First_Part Four 1700 5 First_Part Five 1400 6 Second_Part Six 1900 7 Second_Part Seven 1200 8 Second_Part Eight 1200 9 Second_Part Nine 1200 10 Second_Part Ten 1300 SELECT *, RANK() OVER(ORDER BY salary DESC) AS rank FROM salary_list Result Set id part name sala..