Query to list the 1st 10 prime numbers

General
Enthusiast

Query to list the 1st 10 prime numbers

Hi All,

Is there any way to write a query to list the 1st 10 prime numbers?

or can we list out the prime numbers between 100 and 1000 ?

( without using a table having numbers and without using any macros or stored procedures).

Do we have any functions as such in teradata? is it possible in teradata?

Tags (2)