感謝不盡， 在線等
Define a table primes that has a single column containing all prime numbers up to 100.
create table primes as
select
Here's what your output should look like.
-- Example:
select * from primes;
-- Expected output:
-- 2
-- 3
-- 5
-- 7
-- 11
-- 13
-- 17
-- 19
-- 23
-- 29
-- 31
-- 37
-- 41
-- 43
-- 47
-- 53
-- 59
-- 61
-- 67
-- 71
-- 73
-- 79
-- 83
-- 89
-- 97
uj5u.com熱心網友回復：
解決了嗎？ 通過函式實作可以嗎？uj5u.com熱心網友回復：
WITH T AS(SELECT ROWNUM + 1 RN
FROM DUAL
CONNECT BY ROWNUM <= 100 - 1)
SELECT *
FROM (SELECT RN
FROM T
MINUS
SELECT T1.RN * T2.RN
FROM T T1, T T2
WHERE T1.RN <= T2.RN
AND T1.RN <= (SELECT SQRT(100)
FROM DUAL))
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/96320.html
標籤：高級技術
下一篇：SQL關于分組查詢、累計求和問題