1

Topic: Table output

Hello, help with a problem.
There is such table
ID NAME NBR CUR
1 QQ 1 300
1 QQ 2 200
1 QQ 3 100
2 EE 1 50
2 EE 2 600
2 EE 3 40
It is necessary to lead to a type
ID NAME CUR1 CUR2 CUR3
1 QQ 300 200 100
2 EE 50 600 400
Told not to use union and subqueries. A MB as that case to use case NBR=1-> CUR 1-> Cur2. But I did not find as to deduce the next line in a column

2

Re: Table output

racer888;
Groups

3

Re: Table output

racer888;
The main idea here:
... - Transposing of lines in columns.
Basically - it is reduced to one , without an enclosure.
On versions from 11g and above it is possible to use PIVOT.

4

Re: Table output

Thanks