How to combine two rows into one row with same ID?

mikkom · #1 (**permalink**) 07-08-10, 02:44

I have a data that needs to be arranged from two rows into one row as follow:

From two rows into -->
ID X Text
1234 1 abc
1234 2 xyz

One row -->
ID Text1 Text2
1234 abc xyz

If field X=1, then Text needs be put into field Text1 and if X=2, then Text needs to be put into Text2.

So how I can do that? I think I need to use CASE function somehow?

r937 · #2 (**permalink**) 07-08-10, 06:08

yes, CASE

Code:

SELECT id
     , MAX(CASE WHEN x = 1 THEN text ELSE NULL END) AS text1
     , MAX(CASE WHEN x = 2 THEN text ELSE NULL END) AS text2
  FROM daTable
GROUP
    BY id

mikkom · #3 (**permalink**) 07-08-10, 07:12

It works now. Thanks!

Internet Services

Web Development

Digital Marketing

Consumer Tech