Syntax
ALL [ ( SELECT-Befehl ) ]
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ößer ist als das rating aller Kunden in Berlin.
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.