study

Row_Number() 사용법

intseq 2013. 12. 28. 00:37

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