Convert table column and table row in SQL

Question

I have a table like that:

Day   Item   Value
1      2      5
1      1      4
2      3      7
3      1      6

Now, i want to select like below:

Item  Day1   Day2   Day3
1     4      blank  6
2     5      blank  blank
3     balnk  7      blank

with Day1, Day2, Day3 are value of column 'Day' in first table.

Everyone help me. Sorry about my poor!

I think you should clarify your question a bit with examples of what you have tried so far, and what output you are expecting. See [how to ask a question.](http://stackoverflow.com/help/how-to-ask) — Roman Marusyk, Feb 29 '16 at 08:23
What is Day1, Day2,...? Where does it come from? Please give more details about what you want to do. — dns_nx, Feb 29 '16 at 08:29
Possible duplicate of [Simple way to transpose columns and rows in Sql?](http://stackoverflow.com/questions/13372276/simple-way-to-transpose-columns-and-rows-in-sql) — nibarius, Feb 29 '16 at 08:30
Which RDBMS is this for? Please add a tag to specify whether you're using `mysql`, `postgresql`, `sql-server`, `oracle` or `db2` - or something else entirely. — marc_s, Feb 29 '16 at 08:30

dns_nx · Accepted Answer · 2016-02-29T08:52:27.447

0

From your description, I can provide you this code. I'm not sure, if this is what you want to do / expect. This example works in SQL Server.

SELECT 
    Item,
    case when [DAY] = 1 then value else '' end as Day1,
    case when [DAY] = 2 then value else '' end as Day2,
    case when [DAY] = 3 then value else '' end as Day3
FROM
    [yourtablename]

Now you added orcale as tag. I don't know oracle, but maybe my example provides you a way.

edited Feb 29 '16 at 08:52

answered Feb 29 '16 at 08:39

dns_nx

3,651
4
37
66

thank for help, i'll try – TuHM Feb 29 '16 at 08:56

Convert table column and table row in SQL

1 Answers1