SQL Tips for DB2 LUW

com Marcações: distinct

Entradas de Blog Apresentadas

TODAS AS PUBLICAÇÕES

Distinctly weak type rules with a constrained twist

Visits (5136)

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 it supported along with implementing the Starburst compiler with the research team from the Almaden Research Center. During that time, we started to make SQL more user-extensible with user-defined objects for procedures, functions and data types. The first kind of user-defined data type was... [More]

Marcações: type alias weak rules subtype constraint domain check featured distinct

The trouble of combining DISTINCT with ORDER BY

Comments (4) Visits (44144)

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 "T") the following error is being returned: SQL0214N An expression in the ORDER BY clause in the following position, or starting with "C3" in the "ORDER BY" clause is not valid. Reason code = "2". Why does DB2 raise this error? The reason is simple: It's not... [More]

Marcações: olap by distinct order row_number sybase over

Blogs

SQL Tips for DB2 LUW

SOBRE ESTE BLOG

Links

Marcações

TWEETS RECENTES

Distinctly weak type rules with a constrained twist

The trouble of combining DISTINCT with ORDER BY