Find all prime numbers using SQL--Sieve of Eratosthenes

There is no loop syntax in SQL but we can also do the job just as in other programming languages.

Inspired by a book written by Celko, I also wrote a piece of SQL code to find all prime numbers

in a table populated with natural numbers.
Please refer to Sieve of Eratosthenes