数据库查询语句:SELECT areaname, xssr, ${int(RAND()*10000)} + xssr as xssr_new FROM (select b.areaname, round(sum(a.xssr) / 10000, 2) xssr, round(sum(a.xssr - a.hsxscb + a.hssupzk) / 10000, 2) profit from dbusrdat1.sd_cat a, shoparea_map b where a.mkt = b.shopid and a.hsday = trunc(sysdate) - 1 group by b.areaname order by b.areaname) a where areaname is not null and areaname not in ('安徽省') order by random() limit 5点击预览时报错:因为是模仿的大屏展示示例中的ds1和点地图自动刷新中的示例语句写的,本身并不是很懂这个原理,所以报错就毫无头绪了。相关模仿的原语句为:SELECT pid,省份,销售额,${int(RAND()*100000)}+销售额 as 新销售额 FROM 地图 where pid!='' order by random()limit 3以及:SELECT pid,销售额,${int(RAND()*100000)}+销售额 as 新销售额 FROM 地图 where pid is not null and pid not in('天津市') order by random() limit 5