[SQL] SQL 행번호 이용

물박사의 저장공간 2021. 11. 20. 18:42

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