How can I use Pivot on following format

Question

Following is the output received from the SQL and I want to convert same into the desired result in SQL. Questions are populated from in question master so questions can change in future. I am stuck since long time. I am using Pivot for the first time.

Please open the link to see the SQL output and desired result

enter image description here

Please edit your answer and add the tag for the database vendor - e.g. Is this MS Sql Server? — StuartLC, Apr 11 '15 at 07:22

score 0 · Answer 1 · edited May 23 '17 at 12:06

Assuming Sql Server, this is a simple application of a PIVOT, as follows:

SELECT *
FROM
QuestionsAndAnswers
PIVOT
(
  Min(Answers)
  FOR Question IN ([Question 1], [Question 2], [Question 3])
) pvt;

You will need to take an opinion of an aggregate to be applied to the answers in the pivot, in the event of more than one answer for the same company - I've used Min.

SqlFiddle here.

Note that if you have a variable set of questions, that you'll need to employ a dynamic approach to the pivot, such as this here

How can I use Pivot on following format

1 Answers1