如何取得sum(字段名)中的最大值? select top 1 sum(price) from 表名 group by ProductType order by sum(price) desc 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select max(price) as pricefrom (select sum(price) as price from 表名 group by ProductType) as x select max(price) from( select sum(price) as price from 表名 group by ProductType ) tbTemp select max(price) from( select sum(price) as price from 表名 group by ProductType ) tbTemp asp+sql server 2000 金额=单价*数量;如何约束金额? 我想问个比较基础的问题 时间类型转换和数值换算问题,高手帮帮 100分只求一个试图的写法,急!!! 帮忙找问题:把SQL数据库中数据导出到dbf文件中 SQL Server 2000 反应慢,终端等待时间长 求大家帮忙看我这个数据库!!! 如何压缩数据库? 请问在vc中写的嵌入式sql如何编译? 关于存储过程 请教关于数据库日志文件的问题
from (
select sum(price) as price from 表名 group by ProductType
) as x
( select sum(price) as price from 表名 group by ProductType ) tbTemp
( select sum(price) as price from 表名 group by ProductType ) tbTemp