You are here

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

ALL - All Records

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.