innstory

用distinct在MySQL中查詢多條不重複記錄值

Temperature: 0 °C

2012-07-16Chung

select *, count(distinct name) from table group by name

id name count(distinct name)

1 a 1

2 b 1

3 c 1

select id, name from table group by name

台北市松山區八德路四段650號 Go