=0)```请注意，上述查询语句假设已经存在一个名为"numbers"的表，其中包含从1到100的数字。
以下是1~100的素数表：
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
使用SQL查询语句获取1~100的素数表：
```sql
SELECT number FROM numbers
WHERE number >= 2 AND (
number = 2 OR number % 2 != 0
) AND (
number = 3 OR number % 3 != 0
) AND (
number = 5 OR number % 5 != 0
) AND (
number = 7 OR number % 7 != 0
) AND (
number = 11 OR number % 11 != 0
) AND (
number = 13 OR number % 13 != 0
) AND (
number = 17 OR number % 17 != 0
) AND (
number = 19 OR number % 19 != 0
) AND (
number = 23 OR number % 23 != 0
) AND (
number = 29 OR number % 29 != 0
) AND (
number = 31 OR number % 31 != 0
) AND (
number = 37 OR number % 37 != 0
) AND (
number = 41 OR number % 41 != 0
) AND (
number = 43 OR number % 43 != 0
) AND (
number = 47 OR number % 47 != 0
) AND (
number = 53 OR number % 53 != 0
) AND (
number = 59 OR number % 59 != 0
) AND (
number = 61 OR number % 61 != 0
) AND (
number = 67 OR number % 67 != 0
) AND (
number = 71 OR number % 71 != 0
) AND (
number = 73 OR number % 73 != 0
) AND (
number = 79 OR number % 79 != 0
) AND (
number = 83 OR number % 83 != 0
) AND (
number = 89 OR number % 89 != 0
) AND (
number = 97 OR number % 97 != 0
)
```
请注意，上述查询语句假设已经存在一个名为"numbers"的表，其中包含从1到100的数字。
