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!
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)
< H2 > tables: < H2 > employee employee_orgn: federated primary key (employee_id,orgn_id), index 1, 2:orgn_id employees, index orgn < H2 > sql: < H2 > explain SELECT DISTINCT e.* FROM employee e LEFT JOIN employee_orgn eo ...
this is xml <resultMap id="result_report_QDHW_05" class="com.sunyard.csr.vo.Report_QDHW_05"> <result property="TIME_KEY" column="TIME_KEY" > <result property="...
problem description has a relationship to manage: has multiple app, multiple tags per app, tag, multiple user per tag. User may be under tag11 or tag12 of app1, or under tag21 or tag22 of app2. how to establish a relational table in this case? add...
problem description due to the needs of the course, I want to install Oracle12c in Fedora . Now I have completed the preliminary configuration verification. When I run runInstaller , the Oracle installation interface can appear, but there is an er...
the speed of querying directly on the client is very fast, but the speed in the code is much slower, and the amount of data is about 1 million . this is the query code: List<String> result = new ArrayList<>(); String sql = "SE...
CREATE OR REPLACE PROCEDURE check_in_out (BEGINDATE IN VARCHAR2, ENDDATE IN VARCHAR2, AGENTID IN VARCHAR2, start1 IN NUMBER, limit1 IN NUMBER, AN_O_RET_CODE OUT NUMBER, AC_O_RET_MSG OUT VARCHAR2, COUNTALL ...