DB2中显示行号

select rownumber()over() id from dual

可以取单独某一行的数据

with data as (
 select rownumber() over() as row, city_id
   from dim_pub_city order by city_id
      )
select row, city_id from data where row = 4