# File lib/jdbc_adapter/jdbc_db2.rb, line 60 def add_limit_offset!(sql, options) if limit = options[:limit] offset = options[:offset] || 0 sql.gsub!(/SELECT/i, 'SELECT B.* FROM (SELECT A.*, row_number() over () AS internal$rownum FROM (SELECT') sql << ") A ) B WHERE B.internal$rownum > #{offset} AND B.internal$rownum <= #{limit + offset}" end end