| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Simple query that consumes all temporary space.
On Tue, 25 Jan 2005 16:02:50 -0800, DA Morgan
<damorgan_at_x.washington.edu> wrote:
<snip>
>You can't use GROUP BY and HAVING clauses without an aggregation.
<snip>
Why not? You don't have to specify an aggregate function in the SELECT list of a GROUP BY select. Without a HAVING clause that is functionally the same as specifying DISTINCT. The HAVING clause just lets you be more selective after the grouping.
The statement functionally just does what the OP wants.
Jaap. Received on Wed Jan 26 2005 - 04:57:04 CST
 |
 |