sql help

[bandababu]

data ila undi

column A           column B

Adam                  Y

Bob                    N

Tom                    Y

Hanson               N

 

Column A ni 2 separate columns kinda split cheyyali based on flag condition in column B. kani nulls kooda vasthunnayi split chesinappudu

 

select case when column B = 'Y' then column A end as result1,

case when column B = 'N' then column A end as result2 

from table

 

ee query execute chesinappudu output ila vachindi

 

result A       result B

Tom              Null

Adam           Null

Null              Bob

Null             Hanson

 

But naku output ila ravali

 

result A   result B

tom          Bob

Adam       Hanson

 

 

 

[ARYA]

[Spell_Hunter]

and column b is not null pedithe raada 

[former]

7 hours ago, bandababu said:

data ila undi

column A           column B

Adam                  Y

Bob                    N

Tom                    Y

Hanson               N

 

Column A ni 2 separate columns kinda split cheyyali based on flag condition in column B. kani nulls kooda vasthunnayi split chesinappudu

 

select case when column B = 'Y' then column A end as result1,

case when column B = 'N' then column A end as result2 

from table

 

ee query execute chesinappudu output ila vachindi

 

result A       result B

Tom              Null

Adam           Null

Null              Bob

Null             Hanson

 

But naku output ila ravali

 

result A   result B

tom          Bob

Adam       Hanson

 

 

 

 

Y & N cominations more than 2 vunte emi ravali output?

[mettastar]

7 hours ago, bandababu said:

data ila undi

column A           column B

Adam                  Y

Bob                    N

Tom                    Y

Hanson               N

 

Column A ni 2 separate columns kinda split cheyyali based on flag condition in column B. kani nulls kooda vasthunnayi split chesinappudu

 

select case when column B = 'Y' then column A end as result1,

case when column B = 'N' then column A end as result2 

from table

 

ee query execute chesinappudu output ila vachindi

 

result A       result B

Tom              Null

Adam           Null

Null              Bob

Null             Hanson

 

But naku output ila ravali

 

result A   result B

tom          Bob

Adam       Hanson

 

 

 

Result lo how TOM and BOB are related? Or ADAM and HANSON.. emanna relation undha or rendu columns lo random ga ravacha data .. i mean there is no relation between col A and col B aa?

[bandababu]

32 minutes ago, former said:

Y & N cominations more than 2 vunte emi ravali output?

same thing

oka column Y values, second column lo N values undali without any nulls

[bandababu]

30 minutes ago, mettastar said:

Result lo how TOM and BOB are related? Or ADAM and HANSON.. emanna relation undha or rendu columns lo random ga ravacha data .. i mean there is no relation between col A and col B aa?

column A are person names

column B is a flag column that tells whether person is a parent or a child, If column B = 'Y' then he is a parent . If column B = 'N' then he is a child.

so parent, child two columns laga ravali

[chicchara]

29 minutes ago, bandababu said:

column A are person names

column B is a flag column that tells whether person is a parent or a child, If column B = 'Y' then he is a parent . If column B = 'N' then he is a child.

so parent, child two columns laga ravali

TOM is BOB parent aa?

[4Vikram]

11 minutes ago, chicchara said:

TOM is BOB parent aa?

Yeah vala son TomB @TOM_BHAYYA anta 

[mtkr]

@bandababu

idi oka saari try cheii... srry naa sys lo SQL ledu..

;With A as
(
Select ColA, rn = ROW_NUMBER() OVER (Partition by ColB order by ColA)
From Table
Where ColB = 'N'
), B as
(
Select ColA, rn = ROW_NUMBER() OVER (Partition by ColB order by ColA)
From Table
Where ColB = 'Y'
)
Select res1 = A.ColA, res2 = B.ColA
From A inner join B
on A.rn = B.rn

[ronitreddy]

12 hours ago, bandababu said:

data ila undi

column A           column B

Adam                  Y

Bob                    N

Tom                    Y

Hanson               N

 

Column A ni 2 separate columns kinda split cheyyali based on flag condition in column B. kani nulls kooda vasthunnayi split chesinappudu

 

select case when column B = 'Y' then column A end as result1,

case when column B = 'N' then column A end as result2 

from table

 

ee query execute chesinappudu output ila vachindi

 

result A       result B

Tom              Null

Adam           Null

Null              Bob

Null             Hanson

 

But naku output ila ravali

 

result A   result B

tom          Bob

Adam       Hanson

 

 

 

Tom ki Bob ee enduku ravali? Hanson enduku rakudadu..What relation do they have ? Koncham requirement clear ga seppu