both the EmployeeID and CustomerID columns in our GROUP BY : GROUP BY « Query « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Query
  3. GROUP BY
8> CREATE TABLE Orders (
9>      OrderID int NOT NULL ,
10>     CustomerID nchar (5) NULL ,
11>     EmployeeID int NULL ,
12>     OrderDate datetime NULL ,
13>     RequiredDate datetime NULL ,
14>     ShippedDate datetime NULL ,
15>     ShipVia int NULL ,
16>     Freight money NULL DEFAULT (0),
17>     ShipName nvarchar (40) NULL ,
18>     ShipAddress nvarchar (60) NULL ,
19>     ShipCity nvarchar (15) NULL ,
20>     ShipRegion nvarchar (15) NULL ,
21>     ShipPostalCode nvarchar (10) NULL ,
22>     ShipCountry nvarchar (15) NULL
23> )
24> GO
1>
2>    SELECT CustomerID, EmployeeID, COUNT(*)
3>    FROM Orders
4>    WHERE CustomerID BETWEEN 'A' AND 'AO'
5>    GROUP BY CustomerID, EmployeeID
6> GO
CustomerID EmployeeID
---------- ----------- -----------

(0 rows affected)
1>
2> drop table orders;
3> GO
1>








1.4.GROUP BY
1.4.1.A summary query that counts the number of Billings by Banker
1.4.2.Group by and table join
1.4.3.A summary query with a search condition in the WHERE clause
1.4.4.Extracting partial records using GROUP BY.
1.4.5.GROUP BY with SUM()
1.4.6.both the EmployeeID and CustomerID columns in our GROUP BY
1.4.7.A count for each grouping rather than the full table
1.4.8.Using GROUP BY ALL