Not so sure, but seem like a syntax to declare the following code as a function and naming it so you can refer in the query.
Feb 24, 2022
9
Level 4
What is FUNCTIONS keyword doing in mysql query?
I have this SQL query. which is a solution to this hackerrank sql problem.
SELECT X,
Y
FROM FUNCTIONS F1
WHERE EXISTS
(SELECT *
FROM FUNCTIONS F2
WHERE F2.Y = F1.X
AND F2.X = F1.Y
AND F2.X > F1.X)
AND (X != Y)
UNION
SELECT X,
Y
FROM FUNCTIONS F1
WHERE X = Y
AND (
(SELECT COUNT(*)
FROM FUNCTIONS
WHERE X = F1.X
AND Y = F1.X) > 1)
ORDER BY X;
but i can't find any explanation of this FUNCTIONS keyword. So I request for this to be explained. Thank You.
Please or to participate in this conversation.