SELECT * 

FROM gugu.mileage_del

WHERE mileage <-10000

GROUP BY substring( mileage, 1, length( mileage )-2) 


==> 뒷자리 2자리까지의 숫자를 group by 함.