You are here

Add new comment

ALL - All Records

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.