Tuesday, April 23, 2019

Geneating Odd Number using CTE in SQL server

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

No comments:

Post a Comment