title: Selecting Values From a table as Column Headers
body: <p>I have a table 'propertyvalues' as follows:</p>
  
  <pre>
  ID  FileID  Property  Value<br/>
   1   x       Name      1.pdf<br/>
   2   x       Size      12567<br/>
   3   x       Type      application/pdf<br/>
   4   y       Name      2.pdf<br/>
   5   y       Size      23576<br/>
   6   y       Type      application/pdf<br/>
  ......<br/>
  and so on
  </pre>
  
  <p>How to write a SQL query on the table above to fetch a result like below</p>
  
  <pre> 
  FileID  Name     Size      Type<br/>
    x     1.pdf    12567     application/pdf<br/>
    y     2.pdf    23576     application/pdf
  </pre>