You are here

SOME - Some of 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).

Syntax

Description:

    SOME and ANY mean the same. They are used to apply a logicat constuct to all records at the rigth side of the operator. It's true when the logical construct has the value true on at least one record at the right side of the operator.

    Example:

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

Select all customers, where rating is bigger than the rating of at least one customer in Berlin.

Fehler | AAM

Fehler

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