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: Extending my question. Was: The relational model and relational algebra - why did SQL become the industry standard?

Re: Extending my question. Was: The relational model and relational algebra - why did SQL become the industry standard?

From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Thu, 13 Feb 2003 18:45:21 -0800
Message-ID: <tQY2a.19$O%2.129@news.oracle.com>

"Bob Badour" <bbadour_at_golden.net> wrote in message news:RHY2a.1418$0T3.169406528_at_mantis.golden.net...
> I wonder why someone would request:
>
> select SUM(SAL) from (
> select SAL from emp
> )
>
> when one wants the sum of all salaries.

<user's logic>
I want the sum of all salaries. There are a lot of confusing columns in the Emp view, but I think that all the columns other than Sal are not important for the question I'm asking. Therefore, let's project them away. Now I'm adding up all the salaries. Why the hell am I short of $100K? </user's logic> Received on Thu Feb 13 2003 - 20:45:21 CST

Original text of this message

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