Our server costs ~$56 per month to run. Please consider donating or becoming a Patron to help keep the site running. Help us gain new members by following us on Twitter and liking our page on Facebook!
Current time: July 13, 2025, 8:24 am

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
A question about databases
#1
A question about databases
In 2018, on a test about databases (which I have failed multiple times) at my university, they had this task:
Quote:Napisati T-SQL funkciju koja prima 3 realna broja, te kao rezultat vraća onaj broj koji ima najveću apsolutnu vrijednost. Ako slučajno istu najveću apsolutnu vrijednost imaju dva ili tri broja potrebno je vratiti zbroj tih brojeva.
That is:
Quote:Write a T-SQL function that accepts 3 real numbers, and as a result it returns the number that has the biggest absolute value. If accidentally the same biggest absolute value is had by two or three numbers it is necessary to return the sum of those numbers.
How would you solve that?
Here is my attempt, I do not know if it is correct nor how to actually test it on my computer:
Code:
CREATE FUNCTION max_abs3(@x, @y, @z DECIMAL) RETURNS DECIMAL
BEGIN
    IF ABS(@x)=ABS(@y) AND ABS(@y)=ABS(@z)
    BEGIN
        RETURN @x+@y+@z;
    END;
    IF ABS(@x)=ABS(@y) AND ABS(@x)>ABS(@z)
    BEGIN
        RETURN @x+@y;
    END;
    IF ABS(@x)=ABS(@z) AND ABS(@x)>ABS(@y)
    BEGIN
        RETURN @x+@z;
    END;
    IF ABS(@y)=ABS(@z) AND ABS(@y)>ABS(@x)
    BEGIN
        RETURN @y+@z;
    END;
    IF ABS(@x)>ABS(@y) AND ABS(@x)>ABS(@z)
    BEGIN
        RETURN @x;
    END;
    IF ABS(@y)>ABS(@z) AND ABS(@y)>ABS(@x)
        RETURN @y;
    END;
    RETURN @z;
END;
I have only managed to install SQLite on my computer, and it apparently does not support custom SQL functions.
Reply



Messages In This Thread
A question about databases - by FlatAssembler - May 25, 2022 at 7:43 am
RE: A question about databases - by FlatAssembler - May 26, 2022 at 9:49 am
RE: A question about databases - by arewethereyet - May 26, 2022 at 1:06 pm
RE: A question about databases - by BrianSoddingBoru4 - May 26, 2022 at 12:30 pm
RE: A question about databases - by LadyForCamus - May 26, 2022 at 4:34 pm
RE: A question about databases - by FlatAssembler - May 27, 2022 at 6:26 am
RE: A question about databases - by BrianSoddingBoru4 - May 27, 2022 at 6:35 am
RE: A question about databases - by FlatAssembler - May 27, 2022 at 12:25 pm
RE: A question about databases - by Jehanne - May 26, 2022 at 12:36 pm
RE: A question about databases - by Angrboda - May 26, 2022 at 1:08 pm
RE: A question about databases - by The Valkyrie - May 26, 2022 at 5:53 pm



Users browsing this thread: 1 Guest(s)