Properties

Owner:	dbo
Schema bound:
Encrypted:
Creation Date:	08/06/2000
Description:

Columns

	Name	Data Type	Length	NULL	IsGUID	Description
	ProductName	nvarchar	80
	UnitPrice	money	8

Total: 2 column(s)

Objects that [dbo].[Products Above Average Price] depends on

	Object Name	Owner	Object Type	Dep Level
	Categories	dbo	Table	1
	Suppliers	dbo	Table	1
	Products	dbo	Table	2

Total: 3 objects

SQL

create view "Products Above Average Price" AS
SELECT Products.ProductName, Products.UnitPrice
FROM Products
WHERE Products.UnitPrice>(SELECT AVG(UnitPrice) From Products)
--ORDER BY Products.UnitPrice DESC

See Also

List of views