两个Query用不同的SQL语句 select Title=Convert(Char(30),Title),Price from Titles where Type='business' Select Compute Avg(Price),Max(Price),Min(Price),Sum(price) from Titles where Type='business'
错了,应该是 Select Avg(Price),Max(Price),Min(Price),Sum(price) from Titles where Type='business'
或者用两个Query
select Title=Convert(Char(30),Title),Price
from Titles
where Type='business' Select Compute Avg(Price),Max(Price),Min(Price),Sum(price)
from Titles
where Type='business'
Select Avg(Price),Max(Price),Min(Price),Sum(price)
from Titles
where Type='business'