用SQL Server HAVING子句计算列和平均值

USE [AdventureWorks]

GO

/****** Object:  UserDefinedFunction [dbo].[SalesTotals_fnt]    Script Date: 12/09/2006 11:32:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO


CREATE FUNCTION [dbo].[SalesTotals_fnt]()
RETURNS TABLE

AS RETURN
      (SELECT SalesOrderID, SUM(LineTotal)AS TotalSale
      FROM Sales.SalesOrderDetail
      GROUP BY Sales.SalesOrderDetail.SalesOrderID)