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

  • gungar
     + 0 comments

    MySQL:

    WITH RECURSIVE numbers AS (

    SELECT 2 AS number UNION ALL SELECT number + 1 FROM numbers WHERE number < 1000 )

    SELECT REPLACE(GROUP_CONCAT(number), ',', '&')

    FROM numbers

    WHERE number not IN ( SELECT x.* FROM numbers x

    JOIN numbers y WHERE x.number % y.number = 0 and x.number > y.number)