HackerRank SQL Solutions Tutorial

Binary Tree Node Type Query on HackerRank SQL
Company Details with Employee Counts SQL Query
Query all columns
Student and Friend Salary Report: Insights and Analysis
SQL Query for printing pattern
SQL Query for printing prime numbers
Manhattan Distance Calculation SQL Query
Maximum Total Earnings and Count SQL Query
Students Whose Best Friends Have Higher Salaries SQL Query
Error Calculation and Rounding SQL Query
Comprehensive Contest Metrics Report: Submissions, Views, and More
Project Task Details: Dates and Overlaps Analysis
Pivot Occupation Column in OCCUPATIONS Table on HackerRank SQL
SQL Query for Identifying Symmetric Pairs in Tables

SQL Query for printing prime numbers

❮ Previous Next ❯

Write a query to print all prime numbers less than or equal to . Print your result on a single line, and use the ampersand () character as your separator (instead of a space).

For example, the output for all prime numbers would be:

2&3&5&7

Solution:

WITH RECURSIVE Numbers AS (
    SELECT 2 AS L 
    UNION
    SELECT L + 1
    FROM Numbers
    WHERE L < 1000
)

SELECT GROUP_CONCAT(L SEPARATOR '&') AS PrimeNumbers
FROM Numbers
WHERE NOT EXISTS (
    SELECT 1
    FROM Numbers AS N2
    WHERE N2.L > 1 AND N2.L < Numbers.L AND Numbers.L % N2.L = 0
) AND L <= 1000;

❮ Previous Next ❯

HackerRank SQL Solutions Tutorial

HackerRank SQL Solutions Tutorial

HackerRank SQL Solutions

SQL Query for printing prime numbers

Important Links