Even and odd numbers should be stored in two columns

Question

Hi, My requirement is to print 1 to 20 numbers where even and odd numbers should be as two separate columns, Like as follows Even Odd 2 1 4 3 6 5 8 7 Note: I need it with out creating table Thank you.

Nitin Sontakke · Answer

@Enni, Remember, you specifically mentioned not to use table.

Rajashekar Beesu · Answer

Hi Sai, Have declared @i value with 1 and incremented with 2,then we will get odd numbers if we add 1 to @i will get even numbers.

Enni · Answer

Hi Rajashekar Beesu , Thank you, Can you explain the logic?

Rajashekar Beesu · Answer

Hi , try this one... create table eo(ev int,od int) declare @i int set @i=1 while (@i begin insert into eo values (@i+1,@i) set @i+=2 end select od,ev from eo

Packiaraj Santhiyagu · Answer

Hi, try this one. declare @ index int declare @len int declare @ char char (1) declare @total int -- value setting part set @ index = 1 --by default set index=1 set @len= 20 set @total=0; -- Looping here WHILE @ index BEGIN select case @ index %2 when 0 then @ index end as evenNumber, case @ index %2 when 1 then @ index end as oddNumber, SET @ index = @ index + 1 -- increment the loop value END SELECT @total -- print the result

Nitin Sontakke · Answer

Technically, there is no table declared: ; with cte as ( select 1 [number] 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 union all select 11 union all select 12 union all select 13 union all select 14 union all select 15 union all select 16 union all select 17 union all select 18 union all select 19 union all select 20 ) select [odd], [even] from ( select odd.[number] [odd], even.[number] [even], ROW_NUMBER() over (partition by null order by odd.[number]) [row_number] from cte even left outer join cte odd on even .number = odd .number + 1 ) oe where [row_number] % 2 = 0

Jenith Thakkar · Answer

using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { int i = 0; Console.WriteLine("Even Numbers :"); for (i = 1; i { if( i%2 == 0 ) { Console.Write(i + " "); } } Console.WriteLine("
Odd Numbers :"); for (i = 1; i { if (i % 2 != 0) { Console.Write(i + " "); } } Console.WriteLine(); } } }