← All tables and views
Northwind view
Category Sales for 1997
Native view in the Northwind sample database.
0rows
2 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
CategoryName | TEXT | yes | — | — |
CategorySales | TEXT | yes | — | — |
View definition
CREATE VIEW [Category Sales for 1997] AS
SELECT [Product Sales for 1997].CategoryName,
Sum([Product Sales for 1997].ProductSales) AS CategorySales
FROM [Product Sales for 1997]
GROUP BY [Product Sales for 1997].CategoryNameData preview
Sample records
This recordset has no sample rows.