2 Rows Data into 1 Row [message #681130] |
Thu, 18 June 2020 06:34 |
Genesys
Messages: 45 Registered: August 2010
|
Member |
|
|
Dear All,
Have data like below
code desc val1 val2
123 abc 0 34
123 abc 33
need output as below
code desc val1 val2
123 abc 33 34
any suggestion pls
|
|
|
Re: 2 Rows Data into 1 Row [message #681131 is a reply to message #681130] |
Thu, 18 June 2020 06:42 |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Another college homework question? You need an aggregation: GROUP BY and MAX.
In future, please use [code] tags as described here You have been asked to do this before. More than once.
|
|
|
|
Re: 2 Rows Data into 1 Row [message #681137 is a reply to message #681130] |
Fri, 19 June 2020 06:00 |
Solomon Yakobson
Messages: 3280 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
SQL> with t as (
2 select 123 code,'abc' descr,0 val1,34 val2 from dual union all
3 select 123 code,'abc' descr,33 val1,null val2 from dual
4 )
5 select code,
6 descr,
7 sum(val1) val1,
8 sum(val2) val2
9 from t
10 group by code,
11 descr
12 /
CODE DES VAL1 VAL2
---------- --- ---------- ----------
123 abc 33 34
SQL>
SY.
|
|
|