Mysql-131530

SELECT truncate((PRICE/10000),0)10000 as PRICE_GROUP,COUNT() as PRODUCTS
from PRODUCT
group by PRICE_GROUP
order by PRICE_GROUP asc;

truncate
ex)truncate(1000.12,1)=1000.1
->col에서 자릿수까지 내림