Re: replace subquery with left join

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Thu, 31 Oct 2002 07:07:49 -0500
Message-ID: <3DC11D15.3060200_at_ca.ibm.com>

Take a look at OLAP functions, they are SQL99. Supported at least by Oracle and DB2. Don't knwo about SQL Server.

Cheers
Serge

-- 
Serge Rielau
DB2 UDB SQL Compiler Development
IBM Software Lab, Toronto

Visit DB2 Developer Domain at
http://www7b.software.ibm.com/dmdd/

Received on Thu Oct 31 2002 - 13:07:49 CET

This message: [ Message body ]
Next message: Leandro Guimarães Faria Corsetti Dutra: "Re: Decline of Science: Computer Science and Databases"
Previous message: Moritz Franckenstein: "Re: replace subquery with left join"
In reply to: Hans Sieghart: "replace subquery with left join"
Next in thread: Anders Altberg: "Re: replace subquery with left join"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message