SQL for 1 to 100 prime numbers

Someone asked how to ask for 1 to 100 of prime numbers, so try to write a SQL

With X1 as (select-level + 1 AS-ID from dual CONNECT to level <=), X2 as (select a.ID, a.id/b.id as num from X1 A, X1 b where a.id <> b.id) SELECT DISTINCT ID from x2 where ID not in (SELECT DISTINCT ID from x2 where num is not like ' %.% ') ORDER by 1 ID----------2 3 5 7111317192329313741434753596167717379838997

This article is from the "focus on Oracle Performance Tuning" blog, reproduced please contact the author!

SQL for 1 to 100 prime numbers