11
I have a table 'propertyvalues' as follows:
ID FileID Property Value
1 x Name 1.pdf
2 x Size 12567
3 x Type application/pdf
4 y Name 2.pdf
5 y Size 23576
6 y Type application/pdf
......
and so on
How to write a SQL query on the table above to fetch a result like below
FileID Name Size Type
x 1.pdf 12567 application/pdf
y 2.pdf 23576 application/pdf