- Preface
- Databases
- Tables
- Data and Records
- Operators
- Functions
- Views
- Stored Procedures
- Transactions
- Other SQL commands
- Syntax Definitions
- SQL standads overview
- Links to software manyfacturers documentation pages
- Copyright and Warranty
Syntax
ALL [ ( SELECT-Command ) ]
Description:
ALL is used to select all records of an SELECT statement.
Example:
SELECT * FROM tkunden WHERE rating > ALL ( SELECT rating FROM tkunden WHERE stadt='Berlin' );
Select all customers where rating is biger than the rating of all customers living in Berlin.