Que coincida con: distinct X
RickSwagerman Etiquetas: type alias weak rules subtype constraint domain check featured distinct 4.459 vistas
Background Back in the early 1990s when I first started working on database language architecture, DB2 for Linux, Unix, and Windows was a new DB2 database manager (I believe we called it DB2 for common servers back then) and making a big jump in the SQL that...
del Blog: SQL Tips for DB2 LUWModificado el por RickSwagerman
SergeRielau Etiquetas: olap by order distinct sybase row_number over 4 Comentarios 35.731 vistas
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...
del Blog: SQL Tips for DB2 LUW