-
1. Mysql SELECT @ROWNUM :=@ROWNUM+1 AS IDX, A.* FROM ( SELECT * FROM [조회 대상 테이블] ) A, (SELECT @ROWNUM :=0) R 2. Oracle SELECT ROWNUM AS IDX , A.* FROM ( SELECT * FROM [조회 대상 테이블] ) A