We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
MySQL (This is my approach as a person just getting deeper into SQL):
DELIMITER //
CREATE PROCEDURE PRIME()
BEGIN
DECLARE I INT DEFAULT 2;
DECLARE V INT DEFAULT 1;
DECLARE C INT DEFAULT 0;
DECLARE RESULT VARCHAR(10000) DEFAULT ' ';
WHILE I <= 1000 DO
SET V = 1;
SET C = 0;
WHILE V <= I DO
IF MOD (I, V) = 0 THEN
SET C = C + 1;
END IF;
SET V = V + 1;
END WHILE;
IF C <= 2 THEN
SET RESULT = CONCAT(RESULT, I, '&');
END IF;
SET I = I + 1;
END WHILE;
SET RESULT = SUBSTRING(RESULT, 1, CHAR_LENGTH(RESULT) - 1);
SELECT RESULT AS PrimeNumbers;
END //
DELIMITER ;
CALL PRIME();
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Print Prime Numbers
You are viewing a single comment's thread. Return to all comments →
MySQL (This is my approach as a person just getting deeper into SQL):
DELIMITER // CREATE PROCEDURE PRIME() BEGIN DECLARE I INT DEFAULT 2; DECLARE V INT DEFAULT 1; DECLARE C INT DEFAULT 0; DECLARE RESULT VARCHAR(10000) DEFAULT ' '; WHILE I <= 1000 DO SET V = 1; SET C = 0; WHILE V <= I DO IF MOD (I, V) = 0 THEN SET C = C + 1; END IF; SET V = V + 1; END WHILE; IF C <= 2 THEN SET RESULT = CONCAT(RESULT, I, '&'); END IF; SET I = I + 1; END WHILE; SET RESULT = SUBSTRING(RESULT, 1, CHAR_LENGTH(RESULT) - 1); SELECT RESULT AS PrimeNumbers; END // DELIMITER ; CALL PRIME();