select c.autoid,c.autobrand,c.autotype,avg(c.auto_price) as bj
from
(select a.autoid,b.autobrand,b.autotype,a.auto_price from autoprice a,autoinfo b where a.autoid=b.autoid) c
where c.auto_price > 130-5 and c.auto_price <130+5
group by c.autoid,c.autobrand,c.autotype
order by c.autobrand desc,c.autotype asc
也就是四舍五入的问题！改怎么加上这个条件呢！小弟SQL很菜的请高手帮忙
bj查询出来的
如果数据为112.6425 那么我想取112.6
如果数据为112.6525 那么我想取112.7
------解决方案--------------------------------------------------------
select c.autoid,c.autobrand,c.autotype, round（avg(c.auto_price)，1) as bj
from
(select a.autoid,b.autobrand,b.autotype,a.auto_price from autoprice a,autoinfo b where a.autoid=b.autoid) c
where c.auto_price > 130-5 and c.auto_price <130+5
group by c.autoid,c.autobrand,c.autotype
order by c.autobrand desc,c.autotype asc
例如 SELECT ROUND(150.75, 1) 结果是150.8 请查看sql帮助里round函数
------解决方案--------------------------------------------------------
SELECT ROUND(150.75, 1)
30分也叫散啊。呵呵