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       
Total: 2 column(s)

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

Object Name Owner Object Type Dep Level
  Categories  dbo  Table 
  Suppliers  dbo  Table 
  Products  dbo  Table 
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