SQL Func avg price
SQL
Download (.zip)
CREATE FUNCTION AveragePrice(@booktype varchar(12)) RETURNS money AS BEGIN DECLARE @avg money SELECT @avg = avg(price) FROM titles WHERE type = @booktype RETURN @avg END GO CREATE FUNCTION AveragePrice2(@booktype varchar(12)) RETURNS money AS BEGIN RETURN ( SELECT avg(price) FROM titles WHERE type = @booktype) END GO SELECT title_id, price FROM titles WHERE price > dbo.AveragePrice('business') AND type = 'business' GO SELECT title_id, price FROM titles WHERE price > dbo.AveragePrice2('business') AND type = 'business' GO DECLARE @avg money EXEC @avg = dbo.AveragePrice 'business' SELECT @avg GO
|