com Identificações: row_number X
Hazem Saleh (IBM) Identificações: large row_number data template query pagination db2 volume 2.053 Visitas
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...
do Blog: Hazem Saleh
SergeRielau Identificações: olap by order distinct sybase row_number over 4 Comentários 25.078 Visitas
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...
do Blog: SQL Tips for DB2 LUW