access conut的問題

2010-04-22 12:06 am

如果我有個兩行data係咁...
employeeID department
0001 ABC
0001 ABC
0002 ABC

即係頭兩行record完全一樣
咁用count個陣就會出左3個人
但我只係想顯示2
咁應該點樣做?
就算group左或又distinct但都係出3
拜託!!

回答 (1)

2010-04-22 11:33 am

✔ 最佳答案

SELECT Count(*) AS CountEmployee FROM (SELECT DISTINCT Table1.EmployeeID FROM Table1) A

👍 0 👎 0