每月彙整:三月 2014

MySQL count 不重複的記錄

SELECT COUNT( DISTINCT id ) FROM tablename;

發表於 MySQL | 發表迴響

MySQL SUM總和為NULL問題

SELECT SUM(salary) FROM myTable WHERE user = ‘Power’ SELECT COALESCE(SUM(salary),0) FROM myTable WHERE user = ‘Power’

發表於 MySQL | 發表迴響