Oracle sql problem

the data I have found now is the following result

A B C D
2019.1.2 AAA 1 0
2019.1.3 BBBBB 01
2019.1.2 AAA 0 3
2019.1.3 BBBBB 50

I want to merge this dataset through SQL or through JAVA code

A B C D
2019.1.2 AAA 1 3
2019.1.3 BBBBB 5 1

how do you write this? Can someone help me? Thank you!

Mar.27,2022

SELECT A, B, SUM (C) AS C, SUM (D) AS D from table GROUP BY A, B
this is the result you want to query. If you want to update, you can delete the original and insert it into the
, or you can update and delete the others on one entry (it is better to delete them all and add them again)

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-7bc186-8f05.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-7bc186-8f05.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?