1 to 4 of 4
Sort by

Blog Entry
Usar los percentiles con SQL

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...

Tony Andrews's profile image

Blog Entry
SQL Percentiles

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...

Tony Andrews's profile image

Blog Entry
Ranking and Numbering with SQL

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...

David Simpson's profile image

Library Entry
[F03] Data archived, yet accessible in real-time

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...