Code Library
Home Submit Free Hosting Link To Us Contacts

SQL Func avg price

SQL Func avg price SQL SQL Func avg price 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






Tatet