平均值: insert into table select AVG(列1),AVG(列2),.... from table 最大值: insert into table select MAX(列1),MAX(列2),.... from table 最小值: insert into table select MIN(列1),MIN(列2),.... from table追问
select * from Employees compute avg(EmployeeID),sum(EmployeeID),max(City),Min(Title)
第2个回答 2014-03-17
insert into tableA(C1,C2,C3,,Cn) select avg(c1),avg(c2),avg(c3),,avg(cn)--平均值 group by c1,c2,c3,,cn union select MAX(c1),MAX(c2),MAX(c3),,MAX(cn)--最大值 group by c1,c2,c3,,cn union select MIN(c1),MIN(c2),MIN(c3),,MIN(cn)--最小值 group by c1,c2,c3,,cn
第3个回答 2014-03-17
select itemname, avg(itemvalue) from table group by itemname追问