open

create table MYTEST ( FIRST_NAME varchar(8) not null);
insert into MYTEST select 'Judge' ;
insert into MYTEST select 'Earth' ;
select * from MYTEST;

-- SQL

select row_number() over (order by getdate() ) as ROW_INDEX, FIRST_NAME from MYTEST order by FIRST_NAME asc;

-- SQL 실행결과

ROW_INDEX FIRST_NAME
------------ -------------
1 Earth
2 Judge