db2 "rownum"

Recommended for you: Get network issues from WhatsUp Gold. Not end users.
select id from(
   select ROW_NUMBER() OVER() AS a,id
   from tab
)
where a > 0 and a<50
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Hunter at December 11, 2013 - 12:11 PM