with Tags: row_number X
A very common requirement is to have pagination on the level of the database especially if your query result returns thousands of database records. In this post, I show you how to make database pagination in DB2: http://www.technicaladvices.com/2012/09/03/d...
from Blog: Hazem Saleh
Motivation Yesterday one of my coworkers from India asked for my help in migrating the following SQL statement from Sybase to DB2. SELECT DISTINCT c1, c2 FROM t ORDER BY c3 When this statement is run in DB2 (assuming the appropriate definition of...
from Blog: SQL Tips for DB2 LUW