Sort by

recency

|

1373 Discussions

|

  • + 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;

  • + 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);
    
  • + 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)

  • + 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;

  • + 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