Query.Close; Query.SQL.Text := 'SELECT SUM(单价*数量) AS U FROM 表 GROUP BY 产品名'; Query.Open;Edit.Text := Query.FieldByName('U').AsString;
Query.Close; Query.SQL.Text := 'SELECT 产品ID,SUM(单价*数量) AS U FROM 表 GROUP BY 产品ID'; Query.Open; Edit.Text := Query.FieldByName('U').AsString;
with Query do begin Close; SQL.Clear; SQL.Text := 'SELECT 产品ID,SUM(单价*数量) AS U FROM 表 GROUP BY 产品ID'; Open; end; Edit.Text := Query.FieldByName('U').AsString;
SQL SERVER数据库: fhuibo(Sailor) SELECT 产品ID, SUM(单价*数量) AS U FROM 表 GROUP BY 产品IDOracle数据库 SELECT 产品ID,SUM(NVL(单价,0)*NVL(数量,0)) U FROM 表 GROUP BY 产品ID
edit1.text:=Query1.Fields[0].AsString;
Query.SQL.Text := 'SELECT SUM(单价*数量) AS U FROM 表 GROUP BY 产品名';
Query.Open;Edit.Text := Query.FieldByName('U').AsString;
Query.SQL.Text := 'SELECT 产品ID,SUM(单价*数量) AS U FROM 表 GROUP BY 产品ID';
Query.Open;
Edit.Text := Query.FieldByName('U').AsString;
begin
Close;
SQL.Clear;
SQL.Text := 'SELECT 产品ID,SUM(单价*数量) AS U FROM 表 GROUP BY 产品ID';
Open;
end;
Edit.Text := Query.FieldByName('U').AsString;
fhuibo(Sailor)
SELECT 产品ID, SUM(单价*数量) AS U FROM 表 GROUP BY 产品IDOracle数据库
SELECT 产品ID,SUM(NVL(单价,0)*NVL(数量,0)) U FROM 表 GROUP BY 产品ID