본문 바로가기

study

Row_Number() 사용법

insert into mplus_board_category select 'qnas',

ROW_NUMBER() OVER(ORDER BY idx DESC) AS Row,

tec_id,0,ROW_NUMBER() OVER(ORDER BY idx DESC) AS Row,'','' from teacher