Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sub-selects
Ryan wrote:
>Ive never really had to use these yet and I dont see much in the
>documentation on them. I have heard you can use these in place of group bys
>to improve performance. does anyone have any real world examples?
>
>
>
If you are referrring to the GROUP BY clause ... it has nothing to do
with SUBQUERIES.
They are two entirely different things serving very different purposes.
GROUP BY is used
when using aggregating functions such as COUNT, SUM, AVG. A sub-select
is not going
substitute for this functionality.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Sat Oct 25 2003 - 11:27:56 CDT