Listing 2: Code That Uses TOP 100 PERCENT to Order Views
CREATE VIEW dbo.AllProductSales
AS
SELECT OD.ProductID, sum(OD.quantity) AS Total
FROM northwind.dbo.[order details] AS OD
GROUP BY OD.ProductID
go
CREATE VIEW dbo.AllProductSalesOrdered
AS
SELECT TOP 100 PERCENT OD.ProductID, sum(OD.quantity) AS Total
FROM northwind.dbo.[order details] AS OD
GROUP BY OD.ProductID
ORDER BY Total DESC
go
SELECT * FROM dbo.AllProductSales
	ORDER BY Total DESC
SELECT * FROM dbo.AllProductSalesOrdered
go