Get column field as rows?

Asked Dec 15 '15 at 08:23

Active Jun 04 '22 at 15:37

Viewed 38 times

I have a table from those I need to get the column field as row

course          |orderedid  |name   |address    |phoneNumber
fairy           |1473       |john   |america    |   1234
tales           |1473       |john   |America    |   1234
Admin           |1473       |john   |america    |   1234

I need the result like the below:

course  course2    couse3   orderedid   name    address     phoneNumber
fairy   tales      Admin    1473        john    america     1234

How can I write this SQL query?

edited Jun 04 '22 at 15:37

halfer

19,824
17
99
186

asked Dec 15 '15 at 08:23

Sadda-shutu

1,309
2
18
42

How many courses john may have? – Giorgi Nakeuri Dec 15 '15 at 08:26
thanks for reply @ Giorgi Nakeuri here i have 12 courses – Sadda-shutu Dec 15 '15 at 08:28
Exactly pivot is the solution :) – japzdivino Dec 15 '15 at 08:29
@Japongskie thanks for reply sory to say i am very new to DB i am not understing pivot can you provide me any examples plz.... – Sadda-shutu Dec 15 '15 at 08:31
The sample you are looking is in the comment awhile ago, someone mark your question as duplicated of this: http://stackoverflow.com/questions/24470/sql-server-pivot-examples , the sample is already there.. if will take sometime here in stackoverflow and read the sample , you can understand to the pivot works. – japzdivino Dec 15 '15 at 08:33

Get column field as rows?

0 Answers0