DECLARE @oddnum INT = 1;
;WITH n(n) AS
(
SELECT @oddNum + ((@oddNum-1)%2)
UNION ALL
SELECT n + 2 FROM n WHERE n < 50
)
SELECT ROW_NUMBER() OVER(ORDER BY n ) as ID, n as OddNumber FROM n;
Result :
ID OddNumber
1 1
2 3
3 5
4 7
5 9
6 11
7 13
8 15
9 17
10 19
11 21
12 23
13 25
14 27
15 29
16 31
17 33
18 35
19 37
20 39
21 41
22 43
23 45
24 47
25 49
26 51
;WITH n(n) AS
(
SELECT @oddNum + ((@oddNum-1)%2)
UNION ALL
SELECT n + 2 FROM n WHERE n < 50
)
SELECT ROW_NUMBER() OVER(ORDER BY n ) as ID, n as OddNumber FROM n;
Result :
ID OddNumber
1 1
2 3
3 5
4 7
5 9
6 11
7 13
8 15
9 17
10 19
11 21
12 23
13 25
14 27
15 29
16 31
17 33
18 35
19 37
20 39
21 41
22 43
23 45
24 47
25 49
26 51
No comments:
Post a Comment