Re: group by rollup

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 23 Mar 2001 21:15:43 -0800
Message-ID: <3ABC2D7F.9D7B1312@exesolutions.com>

> for prepare report I use GROUP BY ROLLUP clause
> and I need use in SELECT clause column that not includes into
> GROUP BY ROLLUP clause
>
> what should I do?

Using a subselect is of several possible solutions to the problem.

Use your current SQL as part of the FROM clause and then add in again the source to get the additional field(s).

Daniel A. Morgan Received on Fri Mar 23 2001 - 23:15:43 CST

This message: [ Message body ]
Next message: Tim Lee: "How to change INTERNAL password on NT"
Previous message: Vladimir Pogrebnov: "group by rollup"
In reply to: Vladimir Pogrebnov: "group by rollup"

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US