oracle: select rownum from department sqlserver: select row_number() over (order by id) from department