Tested on SampleDB of local server CREATE procedure int)
#Sql list of prime numbers code
The below code works to find prime numbers in SQL Now similar queries can be used: select 2 as p union all Similar to kordirkos algorithm: select 2 as p union allĬreate temporary table if not exists q engine=memory SELECT * FROM generate_series( 2, 1000 ) xĪns an equivalent version for Oracle: WITH x AS(ĬONNECT BY LEVEL y.x AND remainder( x.x, y.x) = 0 If you prefer SQL, then this works WITH x AS (
Note: a list of prime numbers was copied from.