Even and odd numbers should be stored in two columns

Enni

8y1.5k

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.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke8y ago
@Enni,

Remember, you specifically mentioned not to use table.
Rajashekar Beesu8y ago
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.
Enni8y ago
Hi Rajashekar Beesu,

Thank you, Can you explain the logic?
Rajashekar Beesu8y ago
Hi ,

try this one...

create table eo(ev int,od int)
declare @i int
set @i=1
while (@i<=10)
begin
insert into eo values (@i+1,@i)
set @i+=2
end
select od,ev from eo
Packiaraj Santhiyagu8y ago
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<= @len
    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 Sontakke8y ago
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 Thakkar8y ago
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 <= 30; i++)
{
if( i%2 == 0 )
{
Console.Write(i + " ");
}
}
Console.WriteLine("\nOdd Numbers :");
for (i = 1; i <= 30; i++)
{
if (i % 2 != 0)
{
Console.Write(i + " ");
}
}
Console.WriteLine();
}
}
}