你試試用GROUP BY搭配MAX()看看 SELECT toy_name, MAX(quantity) FROM YourTable GROUP BY toy...
也可以使用<=和>= select * from *table_name* where *datetime_column* >= "...
請試試看這樣 select count(CASE WHEN move BETWEEN -10000 AND -200 THEN 1 END) as count_...
mudkip0406的鐵人檔案