달나라 노트

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..

replace(text, old_text, new_text); text에서 old_text를 new_text로 변환합니다. select replace('123abc123', '1', 'z'); -> 결과 : z23abcz23