You are here

Главная › ALL - alle Werte

Добавить комментарий

ALL - alle Werte

Вс, 25/01/2004 - 12:18 — andre

Syntax

Beschreibung:

    ALL wird vervendet um alle (ohne Ausnahmen) Werte/Tabellenzeilen auszuwählen.

    Beispiel:

SELECT *
 FROM tkunden
 WHERE rating > ALL ( SELECT rating FROM tkunden WHERE stadt='Berlin' );

Alle Kunden selektieren, deren rating grö&szliger ist als das rating aller Kunden in Berlin.

Categories: 
SQL
Datenbanken
DDL
DML

Copyright © 2009. This Object (page with whole content) is open source and can be modifyed and/or copyed unter der terms and conditions of the Universal General Public License (UGPL). This statement does not apply to the UGPL, the copyright statement of this site itself and the logo (top left image on each page). The logo image may be copyed with the page itself, but changing it is not allowed. All other rights on this image are reserved too.