SQL - Column to Row conversion in Report
<p>I have a table with student-name and student-city only. This table is used to find out which student has enrolled online-course from which city.</p>

<p>Table - StudentCity</p>

<pre><code>Name               City

Anand              Mumbai

Vinod              Mumbai

Shailesh           Pune

Rupali             Delhi

Annavi             Pune

Arunabha           Kolkata
</code></pre>

<p>I need the report in the following format:</p>

<pre><code>Mumbai    Pune      Delhi   Kolkata

Anand   

Vinod
          Shailesh
                    Rupali
          Annavi
                            Arunabha
</code></pre>

<p>I am trying to find out a way so that I can use recursive SQL for this. But till now have not succeeded.</p>

<p>Can someone help me out on this.</p>