Select Emp_Id, Salary from Employee
Union
Select Emp_Id,avg(Salary) from Employee
union
Select Emp_ID,Sum(Salary) from Emplpyee
Union
Select Emp_Id,avg(Salary) from Employee
union
Select Emp_ID,Sum(Salary) from Emplpyee
Columns[N]->Footers->(FieldName+Value Type=fvtSum or fvtAvg)
Edit1.Text := DBGridEh1.Columns[0].Footers[0].Value
你有吗?
我发了个贴子,100分求购啊!分不够可以加啊!
http://www.csdn.net/expert/topic/661/661289.xml?temp=.6964685