Advertisement
boky8

Zadatak3 SQL

Jul 16th, 2018
156
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.22 KB | None | 0 0
  1. ALTER PROC GetAverageMilkProductionForYear (
  2.     @year int
  3. ) AS
  4. BEGIN
  5.     SELECT AVG(1.0 * dmp.Liters)
  6.     FROM DailyMilkProduction dmp
  7.     WHERE dmp.Date BETWEEN DATEFROMPARTS(@year, 1, 1) AND DATEFROMPARTS(@year + 1, 1, 1)
  8. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement