ANY - Some of Records

Syntax

Description:

    ANY and SOME are the same. They are used to apply a logical contruct to all records on the right side of the operator.

    Example:

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

Select all customers with rating bigger than rating of at least one of living in Berlin.