How to achieve prime numbers between 2 and 500 using SQL statements? ? Trouble ~~~

amanna

RT, thank you! !! !! !!

kalian2000

Why use Sql statement?

amanna

Forced ~~
Hehe ~~~
Trouble master help ~

amanna

God ~~~
Save me ~~~

guanrui_kobe

#include "stdio.h"
main ()
{
int a [501], i, j;
for (i = 2; i <= 500; i ++)
a [i] = i;
   for (i = 2; i <4; i ++)
        printf ("% d", a [i]);
for (i = 4; i <= 500; i ++)
{
for (j = 2; j <i; j ++)
if (a [i]% j == 0) break;
The
else if (i == j + 1)
printf ("% d", a [i]);
The
}
The

}

guanrui_kobe

Halo, use SQL, depressed

amanna

Hehe ~~~
Help the younger brother to be depressed for a while, SQL is not a big deal ~~

kalian2000

I really don't know how to use Sql statement ..

Learn to help ...

qwer000

qwer000

Interesting, try with a temporary table + cursor, the important thing is to make a loop and record

If you have time, you must write a play for yourself, the landlord ’s idea is very wonderful.

select num from numtable where num% @ i <> 0

numtable stores raw data 2-500, @i is a loop variable
You can use a cursor to make a small loop, and try to filter it with a surface sentence to see if it can come out