Nota del editor: Este artículo fue publicado originalmente en inglés. Con la aprobación del autor, el equipo de IDUG ha creado la traducción que a continuación se presenta. Con las funciones SQL OLAP RANK y DENSE RANK disponibles en programación SQL desde hace un tiempo, resulta bastante...
With the SQL OLAP RANK and DENSE RANK functions being around for a while in SQL programming, it is quite easy to query for the TOP XX from data. Take for example the following query that will return the TOP 5 employees out of the EMP table based on the column SALARY. DENSE RANK will be used...
Beginning in DB2 9, IBM introduced support for On-Line Analytical Processing (OLAP) built-in functions. The first three functions introduced may be used to rank and number rows in a result table. This article will explore these three functions which are available on both DB2 for z/OS and DB2...
We are all witnessing boundaries between OLTP and OLAP applications more and more blurring. Many of today enterprise level applications share the same challenge: manage vast amounts of data, maintain high performance results and keep historical data only a click away. We bring a production...
EU13F03.pdf