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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows 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: Using an alias in the HAVING clause
    ... It seems I can't specify the alias in the WHERE clause or the ... But I can specify it in the ORDER BY clause. ... you can use a CTE and then query the CTE where you can ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.programming)
  • 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)