You are here

Home › SQL - Tutorial and Reference (EN) › Operators › SQL specific Operators

ALL - All Records

Error message

Notice: unserialize(): Error at offset 1842 of 1865 bytes in variable_initialize() (line 1202 of /is/htdocs/wp1033310_AQAMEFYCW9/www/includes/bootstrap.inc).
Sun, 15/02/2004 - 14:02 — andre

Syntax

Description:

    ALL is used to select all records of an SELECT statement.

    Example:

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

Select all customers where rating is biger than the rating of all customers living 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.

Error | AAM

Error

The website encountered an unexpected error. Please try again later.