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.
SELECT LISTAGG(N,'&') WITHIN GROUP(ORDER BY N) PRIME_NO
FROM(
SELECT N
FROM (SELECT LEVEL N FROM DUAL CONNECT BY LEVEL <=1000)
WHERE N > 1
AND NOT EXISTS (
SELECT 1
FROM
(
SELECT LEVEL D FROM DUAL CONNECT BY LEVEL <=1000
)
WHERE D >1 AND D < N AND MOD(N, D)=0
)
);
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 →
SELECT LISTAGG(N,'&') WITHIN GROUP(ORDER BY N) PRIME_NO FROM( SELECT N FROM (SELECT LEVEL N FROM DUAL CONNECT BY LEVEL <=1000) WHERE N > 1 AND NOT EXISTS ( SELECT 1 FROM ( SELECT LEVEL D FROM DUAL CONNECT BY LEVEL <=1000 ) WHERE D >1 AND D < N AND MOD(N, D)=0 ) );