Dear SQL experts
I have recently made a database to collect a lot of data and now I would like to present it in nice ways.
In order to do so I need to format my output in certain ways.
Say I have this data in my database:
ID n m
1 | a | e
1 | b | f
2 | c | e
2 | d | f
Is it then possible to construct an SQL statement which would give me this result:
1 | a | b
2 | c | d
Thanks in advance for your help...