Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g43g2000cwa.googlegroups.com!not-for-mail
From: "Ed Prochak" <ed.prochak@magicinterface.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: selecting top performers
Date: 8 Aug 2005 21:54:38 -0700
Organization: http://groups.google.com
Lines: 18
Message-ID: <1123563277.967380.128580@g43g2000cwa.googlegroups.com>
References: <1123500018.839903.68240@g14g2000cwa.googlegroups.com>
   <42F75B8C.4030509@gmail.com>
   <3lp676F13oli6U1@individual.net>
   <42F765F1.6050200@gmail.com>
   <1123531784.981345.148180@f14g2000cwb.googlegroups.com>
   <1123544538.694033.235750@g43g2000cwa.googlegroups.com>
NNTP-Posting-Host: 69.40.199.63
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1123563285 4079 127.0.0.1 (9 Aug 2005 04:54:45 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 9 Aug 2005 04:54:45 +0000 (UTC)
In-Reply-To: <1123544538.694033.235750@g43g2000cwa.googlegroups.com>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g43g2000cwa.googlegroups.com; posting-host=69.40.199.63;
   posting-account=z8J2OwwAAABzrSXAjma7SXOGeLMZZ_s1
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:121125


joel-garry@home.com wrote:
> So is there PL/SQL in the SQL standard?  :-)

Host languages are mentioned, but not PL/SQL specifically. So, yeah,
you got me.   8^)
>
> I direct the OP to
> http://www.orafaq.com/faq/Server_Utilities/SQL/faq24.htm

A better solution, but still incomplete. My whole point is that
selecting the TOP 10 or MIDDLE 50 is really a display module function.
It doesn't fit the concept of relational databases well at all. The
designers of SQL knew that, which is why we have CURSORS.

 Have a great day,
   Ed