Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: SQL (was: Why using "Group By")

Re: SQL (was: Why using "Group By")

From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Fri, 14 Mar 2003 10:55:57 -0800
Message-ID: <IGpca.8$k63.134@news.oracle.com>


Bob,

I would like to steer discussion away from narrow topics of duplicates and logical identity. Some folks in db field throw in (somewhat irresponsibly) a new term "post relational". There is, obviously, little substance to their claims, because they have little to none novel technique to offer. On the other hand the term might be valid as soon as somebody suggests some new methods, that will expand SQL programming power.

Here is an example demonstrating that ordering might have some rich symantics beyond a mere ordering of the end result:

select

   case when prior ename is NULL
   then 0
   else prior sumsal+sal
   end AS sumsal
from emp
order by ename

What is this: perverted low level SQL, or just plain procedural code? Any comments? Received on Fri Mar 14 2003 - 12:55:57 CST

Original text of this message

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