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.
WITH CTE AS
(
SELECT 2 as first_num
UNION ALL
SELECT first_num + 1 FROM
CTE WHERE first_num <1000
)
SELECT STRING_AGG(a.first_num,'&') FROM CTE AS a
WHERE NOT EXISTS ( SELECT 1 FROM CTE AS b
WHERE a.first_num % b.first_num = 0
AND a.first_num <> b.first_num
)
OPTION(MAXRECURSION 0)
Print Prime Numbers
You are viewing a single comment's thread. Return to all comments →
Using recursion and co-related subquery in MSSQL:
WITH CTE AS ( SELECT 2 as first_num UNION ALL SELECT first_num + 1 FROM CTE WHERE first_num <1000 )
SELECT STRING_AGG(a.first_num,'&') FROM CTE AS a WHERE NOT EXISTS ( SELECT 1 FROM CTE AS b WHERE a.first_num % b.first_num = 0 AND a.first_num <> b.first_num ) OPTION(MAXRECURSION 0)