这是sql server中的一个命令,可以执行
SELECT name, address, SUM(quantity) AS sumquantity
FROM text
GROUP BY name, address
UNION
SELECT 'sum', '', SUM(quantity) AS sumquantity
FROM text
但我不知道怎么加到delphi的adoquery的查询语句中
SELECT name, address, SUM(quantity) AS sumquantity
FROM text
GROUP BY name, address
UNION
SELECT 'sum', '', SUM(quantity) AS sumquantity
FROM text
但我不知道怎么加到delphi的adoquery的查询语句中
SELECT name, address, SUM(quantity) AS sumquantity
FROM text
GROUP BY name, address
UNION all
SELECT ''sum'', '''', SUM(quantity) AS sumquantity
FROM text
');
adoquery.sql.clear;
adoquery.sql.add('sql');
adoquery.open;