mybatis使用达梦数据库sum函数查询总值报错不是 GROUP BY 表达式

原先的sql语句 mysql没问题。。达梦数据报错。。

 	SELECT
		t1.id,
		t1.cityState,
		t1.countyName,
		sum(t1.lossRatio) as lossRatio,
		sum(t1.lossArea) as lossArea,
		sum(t1.light) as light,
		sum(t1.medium) as medium,
		sum(t1.intensity) as intensity,
		sum(t1.stronger) as stronger,
		sum(t1.severe) as severe,
		t1.surveyTime,
		t1.recorder,
		t1.auditor,
		t1.fillinDate,
		t1.status
	FROM
		da_city_stlstj AS t1 
	where 	t1.surveyTime=#{surveytime}

 改后 可以了！

	select 
		t2.*,
		t1.id,
		t1.cityState,
		t1.countyName,
		t1.surveyTime,
		t1.recorder,
		t1.auditor,
		t1.fillinDate,
		t1.status
		from 
	(SELECT
		sum(t1.lossRatio) as lossRatio,
		sum(t1.lossArea) as lossArea,
		sum(t1.light) as light,
		sum(t1.medium) as medium,
		sum(t1.intensity) as intensity,
		sum(t1.stronger) as stronger,
		sum(t1.severe) as severe
	FROM
		da_city_stlstj AS t1 )as  t2,da_city_stlstj as  t1
 	where 		surveyTime=#{surveytime} 

解决方法:看了半天sql语句手册最后发现