SQl query to pull data from one column into 2 columns

Question

I have a data in the table in 1 column with Sectors and countries ..I need to pull sectors in one column and countries in another..Here is the sample data ..Any help is highly appreciated

TYPE    DATA

SECTOR IT
SECTOR Retail   `` 
SECTOR MF`
SECTOR us
region eUROPE
region ASIA

Convert into

Type DataSector   DataCountry
Sector IT         null
Sector Retail     null
sector MF         null
region  null           Us
region null       asia

Squirrel · Accepted Answer · 2016-03-14 02:44:10Z

1

SELECT  Type, 
        DataSector  = case when Type = 'SECTOR' THEN Data END, 
        DataCountry = case when Type = 'REGION' THEN Data END
FROM    The_Table

answered Mar 14, 2016 at 2:44

Squirrel

24.8k5 gold badges41 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

SQl query to pull data from one column into 2 columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related