(SELECt product, quantity, something FROM tablename) UNIOn (SELECt "all" AS product, SUM(quantity) AS quantity, SUM(something) AS something FROM tablename)
这是工作查询。它将在结果的最后添加第四行

(SELECt product, quantity, something FROM tablename) UNIOn (SELECt "all" AS product, SUM(quantity) AS quantity, SUM(something) AS something FROM tablename)
这是工作查询。它将在结果的最后添加第四行