像这样的查询应该怎么用,用CDbcritirea 和find? 用CDbCommand怎么用?CDbCommand是不是要先连接Database??
表:TABLE
id A E C D
select A ,
count(id) as num,
max(E) as maxe,
min(E) as mine,
round(avg(E),2) as avge
from TABLE
where A = XX and …
group by A asc,C asc,D desc
order by A asc