Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER FUNCTION "Natalia"."SredniaUcznia"( @IDSW VARCHAR(10))
- RETURNS DOUBLE
- DETERMINISTIC
- BEGIN
- DECLARE "srednia" DOUBLE;
- DECLARE @sum INTEGER;
- DECLARE @ile INTEGER;
- SET @sum = (SELECT SUM( Poz.ID_OCENY)
- FROM Pozycja_swiadectwa AS Poz
- WHERE Poz.ID_SWIADECTWO = @IDSW);
- SET @ile = (SELECT COUNT (Poz.ID_OCENY)
- FROM Pozycja_swiadectwa AS Poz
- WHERE Poz.ID_SWIADECTWO = @IDSW);
- "srednia" = @sum / @ile;
- RETURN "srednia";
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement