Correspondendo a: distinct X
RickSwagerman Marcações: type alias weak rules subtype constraint check domain featured distinct 4.164 Visualizações
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...
do Blog: SQL Tips for DB2 LUWModificado em por RickSwagerman
SergeRielau Marcações: olap by order distinct sybase row_number over 4 Comentários 33.041 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