A SELECT statement that returns all rows : ALL « Query « SQL Server / T-SQL Tutorial

ALL keyword causes all rows matching the search condition to be included in the result set.
To use the ALL keyword, code it immediately after the SELECT keyword.

7>
8>
9> create table Bankers(
10>    BankerID             Integer,
11>    BankerName           VARCHAR(20),
12>    BankerContactLName   VARCHAR(20),
13>    BankerContactFName   VARCHAR(20),
14>    BankerCity           VARCHAR(20),
15>    BankerState          VARCHAR(20),
16>    BankerZipCode        VARCHAR(20),
17>    BankerPhone          VARCHAR(20)
18> )
19> GO
1>
2> insert into Bankers values (1, 'ABC Inc.','Joe','Smith','Vancouver','BC','11111','111-111-1111');
3> GO

(1 rows affected)
1> insert into Bankers values (2, 'DEF Inc.','Red','Rice', 'New York', 'DE','22222','222-222-2222');
2> GO

(1 rows affected)
1> insert into Bankers values (3, 'HJI Inc.','Kit','Cat',  'Paris',    'CA','33333','333-333-3333');
2> GO

(1 rows affected)
1> insert into Bankers values (4, 'QWE Inc.','Git','Black','Regina',   'ER','44444','444-444-4444');
2> GO

(1 rows affected)
1> insert into Bankers values (5, 'RTY Inc.','Wil','Lee',  'Toronto',  'YU','55555','555-555-5555');
2> GO

(1 rows affected)
1> insert into Bankers values (6, 'YUI Inc.','Ted','Larry','Calgary',  'TY','66666','666-666-6666');
2> GO

(1 rows affected)
1> insert into Bankers values (7, 'OIP Inc.','Yam','Act',  'San Franc','FG','77777','777-777-7777');
2> GO

(1 rows affected)
1> insert into Bankers values (8, 'SAD Inc.','Hit','Eat',  'Orland',   'PO','88888','888-888-8888');
2> GO

(1 rows affected)
1> insert into Bankers values (9, 'DFG Inc.','Sad','Lee',  'Wisler',   'PL','99999','999-999-9999');
2> GO

(1 rows affected)
1> insert into Bankers values (0, 'GHJ Inc.','Bit','Lee',  'Ticker',   'MN','00000','000-000-0000');
2> GO

(1 rows affected)
1>
2> SELECT ALL BankerCity, BankerState
3> FROM Bankers
4> ORDER BY BankerCity
5> GO
BankerCity           BankerState
-------------------- --------------------
Calgary              TY
New York             DE
Orland               PO
Paris                CA
Regina               ER
San Franc            FG
Ticker               MN
Toronto              YU
Vancouver            BC
Wisler               PL

(10 rows affected)
1>
2>
3> drop table Bankers;
4> GO
1>
2>
3>
4>

1.16.ALL
	1.16.1.	The ALL predicate is more restrictive, in that all of the values inside the subquery must satisfy the comparison condition.
	1.16.2.	Finding the Most Recently Shipped Employee Using ALL
	1.16.3.	Finding the Most Recently Shipped Employee Using ALL with NULL Handling
	1.16.4.	Finding the Last Row in Employee Using ALL
	1.16.5.	Finding the First Order for Each Customer Using the ALL Predicate
	1.16.6.	A SELECT statement that returns all rows
	1.16.7.	How the ALL keyword works
	1.16.8.	The ALL operator evaluates to true if the evaluation of the table column in the inner query returns all values of that column.