Table Data

ข้อมูล select wtr_gps_id,provider_name,count(*) from vehicle_wastetruck group by wtr_gps_id,provider_name having count(*)>1 order by 3 desc,2,1

3 records   0 ms
wtr_gps_idprovider_namecount
863835025911129Xsense2
863835026331046Xsense2
864507031079584Xsense2