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

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 - 19:55:57 CET