--假设你的原点坐标为(3,4),半径为10select * from
(
select 0 as X
Union all select 1
Union all select 2
Union all select 3
Union all select 4
Union all select 5
Union all select 6
Union all select 7
Union all select 8
Union all select 9
Union all select 10
) a,
(
select 0 as Y
Union all select 1
Union all select 2
Union all select 3
Union all select 4
Union all select 5
Union all select 6
Union all select 7
Union all select 8
Union all select 9
Union all select 10
) b
where (X-3)*(X-3) + (Y-4)*(Y-4) <= 10*10
(
select 0 as X
Union all select 1
Union all select 2
Union all select 3
Union all select 4
Union all select 5
Union all select 6
Union all select 7
Union all select 8
Union all select 9
Union all select 10
) a,
(
select 0 as Y
Union all select 1
Union all select 2
Union all select 3
Union all select 4
Union all select 5
Union all select 6
Union all select 7
Union all select 8
Union all select 9
Union all select 10
) b
where (X-3)*(X-3) + (Y-4)*(Y-4) <= 10*10
select * from
(
select 3-0 as X
Union all select 3-1
Union all select 3-2
Union all select 3-3
Union all select 3-4
Union all select 3-5
Union all select 3-6
Union all select 3-7
Union all select 3-8
Union all select 3-9
Union all select 3-10
Union all select 3+1
Union all select 3+2
Union all select 3+3
Union all select 3+4
Union all select 3+5
Union all select 3+6
Union all select 3+7
Union all select 3+8
Union all select 3+9
Union all select 3+10) a,
(
select 3-0 as Y
Union all select 3-1
Union all select 3-2
Union all select 3-3
Union all select 3-4
Union all select 3-5
Union all select 3-6
Union all select 3-7
Union all select 3-8
Union all select 3-9
Union all select 3-10
Union all select 3+1
Union all select 3+2
Union all select 3+3
Union all select 3+4
Union all select 3+5
Union all select 3+6
Union all select 3+7
Union all select 3+8
Union all select 3+9
Union all select 3+10
) b
where (X-3)*(X-3) + (Y-4)*(Y-4) <= 10*10
select * from
(
select 3-0 as X
Union all select 3-1
Union all select 3-2
Union all select 3-3
Union all select 3-4
Union all select 3-5
Union all select 3-6
Union all select 3-7
Union all select 3-8
Union all select 3-9
Union all select 3-10
Union all select 3+1
Union all select 3+2
Union all select 3+3
Union all select 3+4
Union all select 3+5
Union all select 3+6
Union all select 3+7
Union all select 3+8
Union all select 3+9
Union all select 3+10) a,
(
select 4-0 as Y
Union all select 4-1
Union all select 4-2
Union all select 4-3
Union all select 4-4
Union all select 4-5
Union all select 4-6
Union all select 4-7
Union all select 4-8
Union all select 4-9
Union all select 4-10
Union all select 4+1
Union all select 4+2
Union all select 4+3
Union all select 4+4
Union all select 4+5
Union all select 4+6
Union all select 4+7
Union all select 4+8
Union all select 4+9
Union all select 4+10
) b
where (X-3)*(X-3) + (Y-4)*(Y-4) <= 10*10