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.
  1. Prepare
  2. SQL
  3. Alternative Queries
  4. Print Prime Numbers
  5. Discussions

Print Prime Numbers

Sort by

recency

|

1373 Discussions

|

  • 23a31a04m3
     + 0 comments

    WITH RECURSIVE numbers AS ( SELECT 2 AS n UNION ALL SELECT n + 1 FROM numbers WHERE n < 1000 ), primes AS ( SELECT n FROM numbers WHERE n NOT IN ( SELECT n1.n FROM numbers n1 JOIN numbers n2 ON n2.n < n1.n AND n1.n % n2.n = 0 WHERE n2.n > 1 ) ) SELECT GROUP_CONCAT(n SEPARATOR '&') AS prime_numbers FROM primes;

  • eddy_rene_c
     + 0 comments
    with cte_r as(
    select 2 as n 
    union all 
    select n+1 from cte_r where n < 1000  
),

check_prime as(
    select a.n 
    from cte_r a 
    left join cte_r b 
    on b.n >= 2 
        and b.n <= sqrt(a.n) 
        and a.n % b.n = 0
    where b.n is null
)
SELECT STRING_AGG(n, '&') 
       WITHIN GROUP (ORDER BY n)
FROM check_prime
OPTION (MAXRECURSION 1000);

  • amrapali17
     + 0 comments

    WITH CTE_B AS (SELECT 2 AS START_NUM FROM DUAL ) , CTE_R(MOD_NUM) AS ( SELECT START_NUM AS MOD_NUM FROM CTE_B UNION ALL SELECT MOD_NUM + 1 FROM CTE_R WHERE MOD_NUM <=1000 ) SELECT LISTAGG(n.mod_num,'&') WITHIN GROUP (ORDER BY n.mod_num) FROM CTE_R n where not exists(select 1 from CTE_R d where d.mod_num < n.mod_num and d.mod_num > 1 and mod(n.mod_num ,d.mod_num) =0)

  • shaileshahire061
     + 0 comments

    WITH RECURSIVE numbers AS ( SELECT 2 AS n UNION ALL SELECT n + 1 FROM numbers WHERE n <= 1000 ), divisors AS ( SELECT n.n AS num, d.n AS di FROM numbers n JOIN numbers d ON d.n <= FLOOR(SQRT(n.n)) ), non_primes AS ( SELECT DISTINCT num FROM divisors WHERE num % di = 0 ), primes AS ( SELECT n.n AS prime FROM numbers n WHERE n.n NOT IN (SELECT num FROM non_primes) ) SELECT GROUP_CONCAT(prime ORDER BY prime SEPARATOR '&') AS prime_list FROM primes;

  • chethan2913
     + 0 comments

    with recursive cte as( select 2 as num union all select num+1 from cte where num < 1001 ), prime_num as ( select num from cte a where not exists ( select 1 from cte b where a.num > b.num and a.num%b.num = 0 ) ) select group_concat(num separator '&') from prime_num