Blobonator Blobonator - 2 years ago 92
SQL Question

SQL: Split Dataset into two columns

I have a table like this:

Now I want a table like this with a SELECT command:

time1 and value1 is from the data with c_id=4,
time2 and value2 is from the data with c_id=5

Is it possible to create a SELECT command to do that?

I hope you can help

Answer Source

Yiu can use an inner join

select a.time as time1, a.value as value1, b.time as time2, b.value as value2
from my_table as a 
inner join my_table as b on a.time = b.time
and a.c_id= 4
and b.c_id= 5;
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download