close
SELECT 欄位, COUNT(*)
FROM 資料表
GROUP BY 欄位
例:
SELECT city, COUNT(*)
FROM country
GROUP BY city
全站熱搜
SELECT 欄位, COUNT(*)
FROM 資料表
GROUP BY 欄位
例:
SELECT city, COUNT(*)
FROM country
GROUP BY city
留言列表