Oracle SQL query joining same table

Question

I have a table like this:

                 items
id            old_new     object 

1               o         pen
2               n         house
3               o         dog
4               o         cat
5               n         carrot

I would like the select return:

id    new_object     old_object

1        null          pen
2        house        null
3        null         dog
4        null         cat  
5        carrot       null

Do I need to use an outer join on the same table?

score 2 · Accepted Answer · 2015-12-01 12:19:37Z

2

No join needed:

select id, 
       case when old_new = 'n' then object end as new_object,
       case when old_new = 'o' then object end as old_object
from the_table
order by id;

edited Dec 1, 2015 at 12:19

answered Dec 1, 2015 at 12:15

user330315

Sign up to request clarification or add additional context in comments.

1 Comment

Jorge Campos Over a year ago

How would this get the results OP wants? It would just return the old_new column wich is just N or O

Collectives™ on Stack Overflow

Oracle SQL query joining same table

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related