Re: SQL Anfrage zu 'Es existiert genau ein ....'

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dieter Noeth (dnoeth_at_gmx.de)
Date: 05/06/04 

Date: Thu, 06 May 2004 10:51:32 +0200

Stefan Oedenkoven wrote:

> ja so ist's richtig - nur dass 'Group' eine Aggregatfunktion ist und nicht
> zu SQL-92 gehört ;-(

Wer hat dir denn diesen Unsinn erzählt?

7.7 <group by clause>

Function

Specify a grouped table derived by the application of the <group by
clause> to the result of the previously specified clause.

Format

<group by clause> ::=
     GROUP BY <grouping column reference list>

<grouping column reference list> ::=
     <grouping column reference> [ { <comma> <grouping column reference>
}... ]

<grouping column reference> ::=
     <column reference> [ <collate clause> ]

...
Leveling Rules

1) The following restrictions apply for Intermediate SQL:

   a) Conforming Intermediate SQL language shall not contain any
     <collate clause>.

2) The following restrictions apply for Entry SQL in addition to
   any Intermediate SQL restrictions:

     None.

Dieter

Relevant Pages

  • Re: How do the records retrieve from data base when using sql statements?
    ... Just use an order by clause. ... guaranteed to be returned in the correct order in you don't specify an order ... SQL statement. ... This means that the keys are located continuously and every "insert" ...
    (comp.sys.ibm.as400.misc)
  • Re: Can I create an index on a view?
    ... Using AQUA DATA STUDIO with a connection to our iSeries, ... view using SQL and I am trying to create an index on this view using ... No. although you can specify a view in the from clause of a select ...
    (comp.sys.ibm.as400.misc)
  • Re: Better "Join" vs "Where" clause?
    ... running the SQL directly, in the SQL Server tools, rather than ... WHERE clause has been deprecated, ... AFAIK one cannot perform an outer join in Access without using the explicit ...
    (microsoft.public.access.queries)
  • Thanks
    ... Thanks for "With" clause, ... Why are you formatting data in the back end? ... how to use custom column heading in where clause ... This only works on SQL 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: Performance degradation with view and "left outer join" vs. "from x, outer y"
    ... Turned Every Which Way But Loose", I reminded the attendees that the ANSI SQL '92 parsing rules REQUIRE that filters in the WHERE clause of a query MUST be processed POST-JOIN in order for an RDBMS to be compliant. ... That means that your filter, c.custid = "AB1234", is applied after all rows of the customer table have been LEFT OUTER JOINed to the my_view VIEW with the results stored into a temp table. ... Now if I use the informix extended outer join syntax: ...
    (comp.databases.informix)