我有以下SQL。G1和G2大多是一对一的关系。有些是一对多的关系。下面的SQL将显示太多的"Total2“。当Total2和G1与G2是一对一时,是否可以删除这些G2行?
SELECT CASE WHEN GROUPING_ID(G1) = 1 THEN 'Total1' ELSE G1 END,
CASE WHEN GROUPING_ID(G2) = 1 THEN 'Total2' ELSE G2 END,
SUM(a),
SUM(b),
count(*)
FROM data
GR
我有下面的表格 CREATE TABLE relationships_group (
username TEXT NOT NULL,
position TEXT NOT NULL,
sub_group TEXT NOT NULL,
big_group TEXT NOT NULL
);
INSERT INTO relationships_group (username, position, sub_group, big_group) VALUES
('A', '1', 'S1', 'G1')