display data horizontally

Question

I have written a code like this

SELECT * FROM TestTable

This gets the output in a vertical view.

ID | Name
1  | John
2  | Mckensy
3  | Valneech
4  | Zeebra

However, I need to display it horizontally.

1    | 2       | 3        | 4
John | Mckensy | Valneech | Zeebra

How can one do this?

That is called `pivoting`. In which engine are you trying to accomplish? (SQL Server, MySQL, Oracle...) — Edu, May 13 '16 at 09:27

Aritra Bhattacharya · Answer 1 · 2016-05-13T10:37:35.037

0

You can use pivot for achieving the requirement. Since you have not posted any data model, I have drafted a rough logic. Please check it if works

Static

select * from your table
pivot (name for id in ([1],[2],[3],[4])) as anyrandomname

For your reference you can refer to this link.

https://blogs.msdn.microsoft.com/spike/2009/03/03/pivot-tables-in-sql-server-a-simple-sample/

edited May 13 '16 at 10:37

answered May 13 '16 at 09:39

Aritra Bhattacharya

720
1
7
18

Here you have input id 1 2 3 4 static. But I have lot of data. I don't want to put static data. What should do it? – Md. Abdul Masud Rana May 13 '16 at 09:47
which database are you using @Md.AbdulMasudRana – Aritra Bhattacharya May 13 '16 at 10:19
try this link @Md.AbdulMasudRana http://stackoverflow.com/questions/13372276/simple-way-to-transpose-columns-and-rows-in-sql – Aritra Bhattacharya May 13 '16 at 11:53

score 0 · Answer 2 · answered May 13 '16 at 09:43

0

select (select Name from test where ID=1) as 1,
       (select Name from test where ID=2) as 2,
       (select Name from test where ID=3) as 3,
       (select Name from test where ID=4) as 4
from test
group by 1,2,3,4

answered May 13 '16 at 09:43

kostas

461
5
13

display data horizontally

2 Answers2