Path: news.easynews.com!newsfeed1.easynews.com!newsfeed2.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!feed.news.nacamar.de!fu-berlin.de!uni-berlin.de!pd9e21689.dip.t-dialin.NET!not-for-mail
From: "Oliver S." <Follow.Me@gmx.net>
Newsgroups: comp.databases.oracle.misc
Subject: Re: inline view vs. subquery
Date: 6 Apr 2003 12:39:21 GMT
Lines: 11
Message-ID: <Xns93559516FE27AFollowMeGmxNet@130.133.1.4>
References: <3e8dbd1a$0$26102$91cee783@newsreader01.highway.telekom.at> <3E8DEB96.B1B22ED0@exxesolutions.com>
NNTP-Posting-Host: pd9e21689.dip.t-dialin.net (217.226.22.137)
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: fu-berlin.de 1049632761 7852027 217.226.22.137 (16 [11719])
User-Agent: Xnews/5.04.25
X-No-Archive: yes
X-Face: W\M1z7T[v.0#O%voq,O5{i&fR=R$8,">7^]?q+Mse74CK&~/Q#l?D5f.[:$7QVB3~IXnb`'2Dg7`AZ92==oNLeS?UY7>4q+I0cC]#f#@dHGY,1*"7\z>>]i{I?dy'SHRHamQp9R{DfyA@w$G{0^f==Ah"DYV)wmZNq!>[*YMKA%1I*,f8z2Tio`7pfO>Zw3SF%R>hKPx>DNAd1&(902K+<|H\QwL3'Ibw*]0|^<iW`Z~
Xref: newsfeed1.easynews.com comp.databases.oracle.misc:95929
X-Received-Date: Sun, 06 Apr 2003 05:39:01 MST (news.easynews.com)

> SELECT field1
> FROM (
>    SELECT field1, count(*)
>    FROM sometable
>    GROUP BY field1);

 AFAIK you have to provide a table alias for an inline-view; so the
last line f.e. must be "GROUP BY field1) NAME;".

-- 
C++ is the only feasible way to write large C-programs