Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SUM of rows without group by

mist123Apr 23 2021 — edited Apr 23 2021

Hi All,

select '123-10'INV_NO,	'123_BB' Vendor_no	,'Dec-08' INV_DOP	,2485 amount,	2485 Amount1 from dual
union all
select '123-10'INV_NO,	'123_BB' Vendor_no	,'Dec-09' INV_DOP	,-1225 amount,	-1225 Amount1 from dual
union all
select '123-10'INV_NO,	'123_BB' Vendor_no	,'Dec-09' INV_DOP	,1225 amount,	1225 Amount1 from dual

I want to sum amount,amount1 column values without group by in oracle sql?
Expected one
image.pngOracle version 11.2
This post has been answered by Frank Kulash on Apr 23 2021
Jump to Answer
Comments
Post Details
Added on Apr 23 2021
7 comments
10,591 views
1 mention