Correspondendo a: row_number X
Hazem Saleh (IBM) Marcações: large row_number data template query pagination db2 volume 2.384 Visualizações
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/db2-...
do Blog: Hazem Saleh
SergeRielau Marcações: olap by distinct order row_number sybase over 4 Comentários 29.076 Visualizações
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