[SQL] SQL 행번호 이용

Oracle:

select rownum, name, sex, age
from examdataset
where sex = 'M'
and rownum between 100 and 200

 

SybaseIQ:

select rownum = NUMBER(*), name, sex, age
from examdataset
where sex = 'M'
and rownum between 100 and 200